topic Need help with SET ANALYSIS statement in QlikView

Need help with SET ANALYSIS statement

Wed, 25 Sep 2013 21:36:49 GMT

I have three prices for each item that we sell:

Billed Price, Entitlement Price, List Price

for each: labor and material

Entitlement Price is the only selection which may be NULL

I have the pdf by Mackay on Set analysis, but it also assumes just a touch more knowledge than I have,

after one week. . . but I can't figure out from reading it, how to select a set with one parameter equal to

and the second parameter not null or greater than zero

any suggestions?

sum({$<Labor={'Y'},IsNum(Entitlement_Rate)>} Billed)

thank you in advance. .

MayilVahanan — Wed, 25 Sep 2013 21:46:14 GMT

Try like this

sum({<Labor={'Y'},Entitlement_Rate = {">0"}>} Billed) //greater than zero

sum({<Labor={'Y'},Entitlement_Rate = {"*"}>} Billed) //get not null value

Wed, 25 Sep 2013 21:58:16 GMT

Mayil Vahanan Ramasamy

Thanks Mayil Vahanan Ramasamy - works like a champ!