Set Analysis - Variable

Mon, 15 Dec 2014 16:56:45 GMT

Hello

I have defined a variable as

=(Count({<NumberOfParks={">=$(threshold)"}>}NumberOfParks))

It counts the number of times a field 'NumberOfParks' has crossed a threshold value. Right now it takes into consideration the complete set of Dimension (Years in this case). How can I restrict my variable to consider only a subset of data and then compute the count of NumberOfParks? What will be the Set Analysis Expression for this variable?

Please find attached the sample. Variable I'm talking about is 'counter'. I want counter to consider only Years till 2002 and leave the Year '2003' from consideration for calculating NumberOfParks.

Thanks!

Re: Set Analysis - Variable

giacomom — Mon, 15 Dec 2014 17:08:11 GMT

Hi Nishant,

you can use the following expression:

=(Count({<Years = {"<=2002"}, NumberOfParks={">=$(threshold)"}>}NumberOfParks))

You can add filters to other fields just comma-separating them between the < > brackets.

Regards,

Giacomo

topic Set Analysis - Variable in QlikView

Set Analysis - Variable

Re: Set Analysis - Variable