Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Set Analysis - Variable

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!

1 Solution

Accepted Solutions
Partner
Partner

Re: Set Analysis - Variable

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

View solution in original post

1 Reply
Partner
Partner

Re: Set Analysis - Variable

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

View solution in original post