topic FirstSortedValue() and Set Analysis in QlikView

FirstSortedValue() and Set Analysis

scotthan — Wed, 16 Nov 2011 03:04:37 GMT

I can't seem to get the result of my FirstSortedValue function to work in Set Analysis.

If I have a variable:

vTestDeal = FirstSortedValue(KeyDeal, Proceeds)

...which yields 10 and a set analysis expression:

Sum({$<KeyDeal = {$(vTestDeal)} Measure)

then you would think that I would get the Sum of the Measure where KeyDeal = 10. However, the chart doesn't calculate and I get a "No data to display" error.

If I replace $(vTestDeal) in the set analysis with the number 10, my data comes up correctly. This made me think it might be a datatype issue or something, but experimenting with num and text functions and using single quotes didn't solve my issue.

Anyone have any ideas?!

Thanks,

Scott

FirstSortedValue() and Set Analysis

Wed, 16 Nov 2011 05:58:40 GMT

Scott can you try with:

Sum({$<KeyDeal = {"$(vTestDeal)"} Measure)

Regards,

Kiran.

FirstSortedValue() and Set Analysis

SunilChauhan — Wed, 16 Nov 2011 06:19:55 GMT

use beelow code

Sum({$<KeyDeal = {"$(vTestDeal)"} <}Measure)

FirstSortedValue() and Set Analysis

Wed, 16 Nov 2011 06:34:07 GMT

as KeyDeal returns numeric value then to compare it with vTestDeal you have to convert it into numeric:

Sum({$<KeyDeal = {$num#(vTestDeal)} Measure)

try it.

regards

FirstSortedValue() and Set Analysis

scotthan — Wed, 16 Nov 2011 15:44:33 GMT

Thanks everyone, I was able to wrap my variable in a num function and use the doubel quotes to get my answer.