Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

If and set analysis not working for this case scenario

Hi All,

     I'm pulling my hair with this one, I feel like I'm almost there.... I've got a big table with 1 year of data, I've simply added a rowno() 'RN' as one more column in my load script increasing +1 along all my table.

     I have to take the corresponding value for (90%)th  of records for each month. I'm already calculating it in a straight table, the problem is when I try to use the expression in set analysis or if functions.

     Take a look to this table... Min/max = min/max row for that month. Row = # of row that corresponds to the 90% item of max rows.

    

The column I'm trying to get is TAT, so in last column the expression is:  =if(RN=$(=min(RN)+(round(count(RN)*0.9))-1),TAT) or set analysis: =max({<RN={$(=min(RN)+(round(count(RN)*0.9))-1)}>} TAT)

     The problem is, as you can see, circled in red, that it is comparing just vs the global value, not the one in each row. Any ideas how to make it work?

90.png

1 Reply
Not applicable
Author

58914 is not the value of RN, that the reason set anlaysis is not working...

i have attached sample app for your reference .. if possible attache you sample app .. we will try to give the correct expersion ...