Newest 'qlik-expression' Questions - Stack Overflow

Questions tagged [qlik-expression]

The tag has no usage guidance, but it has a tag wiki.

0
votes
1answer
17 views

QlikView Sort Expression MATCH with an IF expression inside

I am trying to create a custom sort expression using an IF statement. I have the following IF Expression: =IF(VOTA >= -15 AND VOTA <= 15, '0', IF(VOTA >= -60 AND VOTA <= -16, '-1 to 0', ...
0
votes
1answer
34 views

How can convert a field to uppercase in Qlikview and calculate the count based on the substring?

I want to convert a field values to upper case in qlikview My Query is SQL SELECT * FROM "mt_table"; My result table is as follows, I want to get the count of each Desc. For eg: I want to get the ...
-1
votes
1answer
7 views

QlikView Expression that ignores some selections and contains where explicit values

I have a basic expression SUM(value). I want to modify this expression so it does 2 things: Ignores all list box selections except one (yearperiod) and contains explicit where conditions. Pseudo ...
0
votes
1answer
23 views

QlikView Using an expression result as a selection or list box

I have a simple straight table that has a dimension and an expression. =If(Only({1}YOURFIELD) - Above(Only({1}YOURFIELD)) = 1, 'Match', 'Check') The expression either outputs Match or Check. ...
0
votes
1answer
7 views

QlikView Check if rows are continuous (1, 2, 3, 4, 5 etc) in a table

I have a Table box that contains a single field "Numb": Sample Data: Numb A1001 A1002 A1003 A1004 A1005 A1006 A1007 A1008 A1009 A1010 A1011 A1012 A1014 A1015 A1016 A1017 A1018 A1020 I want to have ...
0
votes
1answer
7 views

QlikView Default selection trigger - previous + current year minus current month

I want to create a sheet trigger to select the previous year and the current year but not the current month. If for example we were in 201604... Sample data is as follows: 201511 201512 201601 ...
0
votes
0answers
47 views

How to fix 'Document failed to load' error after creation of xxx-prj folder for qlikview document

When I create xxxx.-prj folder for my xxxx.qvw and then open and save my xxxx.qvw it puts all the xml files in xxxx-prj folder. Buthen when I close xxxx.qvw file and reopen it, it gives me error ...
0
votes
1answer
12 views

QlikView aggr more than one value excluded in list box

I have a list box that is powered by an expression to hide 1 value. =aggr(only({<[name]-={John}>}[name]),[name]) But i want to add a second name to this. I have tried... =aggr(only({<[name]...
0
votes
1answer
9 views

QlikView Using Accumulate 12 steps back for MAT graph, but cant limit date range

I have a line chart which has two dimensions: Yearperiod = 201601, 201602, 201603 etc Acgroup = FAB, BOB, TOE, QUE etc And one expression: SUM(Quantity) This also has Accumulate 12 steps back ...
0
votes
1answer
11 views

QlikView WHERE condition in chart calculated dimension

I have a chart with a calculated dimension it contains 4 possible values A, B, C, or D however in my bar chart i only want it to contain B and C I have tried: =MATCH(CATEGORY, 'B','C',) But this ...
1
vote
1answer
11 views

Qlikview use IN rather than = in a variable in an expression

I have a variable in an expression that SELECTS bottles. sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1) I would like it to be able to select where RCPT equals ...
1
vote
1answer
8 views

QlikView expression for last 12 months & DISTINCT & not changed by selections

I have a few expressions: =COUNT(SUPP) Gives me 9316 which is correct as it is the total number. =COUNT(DISTINCT SUPP) Gives me 3429 which is correct as it is the total distinct number. =ROUND(...
0
votes
1answer
24 views

QlikSense Set analysis SUM expression with explicit less than and ignore selections

I have an expression in QlikSense: Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={$(=NUM(Month(today()),'#'))}>}MOVES) Which gives me the SUM of MOVES from 2018 (previous year) in MONTH 6 (...
0
votes
1answer
382 views

Qlikview ignore selection in text box (object)

I have a text box that contains an expression, however i dont want it to be affected by the selections in the list boxes. =SUM(IF( (date(Monthname(C_DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0)...
0
votes
1answer
402 views

Qlikview Count of ids in last 12 months in text object (box)

I have two fields in my table Date & ID, i want to put in a text box the count of all the ids for the last 12 months. This returns nothing: =Num(count({$<DATE={'>=$(=AddMonths(Today(),-12))...