Stack Overflow
Stack Overflow

Questions tagged [qlik-expression]

Qlik expressions are defined in the Expression Editor.

96 questions
0
votes
3 answers

Nested Set Analysis in QlikSense

My User_ID has several images and with this piece of code I receive the largest IMAGE_NR . max({$ } IMAGE_NR) Every image number is linked to an IMAGE_ID. How do I get this? In words: Give me IMAGE_ID where IMAGE_NR =…
mediii
  • 97
  • 2
  • 12
0
votes
1 answer

Qlikview iterate result set of temp table using forloop

I want to iterate the ResultSet of a TempTable. For eg: MyTmpTable: set emails = 'abc@xyz.com','qwe@xyz.com','asd@xyz.com'; for each mail in $(emails) //Api call with Id https://myapiurl/$(mail) next This works fine. We tested with…
Gnik
  • 7,120
  • 20
  • 79
  • 129
0
votes
0 answers

Difference in days between 2 columns in MS Power BI

I am trying to calculate the number of days between two columns. Below is an expression in qlik sense that I would like to translate into DAX: LPO_DATE - (CLM_INTM_DT) +1 I tried this in DAX but I don't think it is correct: V_TurnAround_Time…
MIRROR
  • 61
  • 1
  • 2
  • 10
0
votes
0 answers

How can do API call in a Loop and consolidate its result in a Temp table?

I want to do something as follows in Qlikview. Need to call the API in the loop till the resp becomes empty array. Also need to append next value in the URL from the response. TempTable: Let next = ''; Let apiUrl = https://myapiurl; do { resp =…
Gnik
  • 7,120
  • 20
  • 79
  • 129
0
votes
1 answer

How can get I get relational data from another table and calculate the average in Qlikview?

I have relationship with 2 tables Table 1 - Process Table 2 - Process History Here the relationship is Id(Process table) and ProcessId(Process history table) I want to calculate the Average Networking days of all the processes. For eg: nwd =…
Gnik
  • 7,120
  • 20
  • 79
  • 129
0
votes
2 answers

Date function on Field not working on a count

I have a Count which is giving me the following error: Error in set modifier expression The Expression is: =Count({} IDID) STARTTIMEDATE is in the format of YYYY-MM-DD HH:MM:SS:XXXXXX
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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', IF(VOTA >= -120 AND VOTA <= -61, '-2 to -1', IF(VOTA >= -180…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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 count of Developers. Here Desc is entered manually.…
Gnik
  • 7,120
  • 20
  • 79
  • 129
0
votes
1 answer

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. However I cannot select the expression results to only…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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 a second table box (or straight table whatever…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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 201602 201603 201604 Selection I would want would…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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]-={John,…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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 ticked. Now the data i get in the chart is correct and…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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 just numbers them.
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

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

I have an expression in QlikSense: Sum({$}MOVES) Which gives me the SUM of MOVES from 2018 (previous year) in MONTH 6 (current month) What I want is the SUM of MOVES from 2018…
Matt
  • 14,906
  • 27
  • 99
  • 149
1 2 3 4 5
6
7