topic Re: How to include the selected months in the set analysis ? in QlikView

How to include the selected months in the set analysis ?

bob654321 — Sat, 16 Nov 2024 01:33:00 GMT

I'm using this expression to get the counts.

Count({<Month,MonthYear={'$(vMaxMonthYear)'}, fnl_determ_qtr={$(vSelectedQuarter)}>}DISTINCT ID))

But the problem is the expression is only displaying the counts for maximum month in a particular quarter if quarter value in the listbox selected. How to calculate the counts for all the months instead of just maximum month in a quarter ?

Re: How to include the selected months in the set analysis ?

Arthur_Fong — Fri, 10 Jan 2020 02:42:14 GMT

Try:

Count({< fnl_determ_qtr={$(vSelectedQuarter)}>}DISTINCT ID))

Re: How to include the selected months in the set analysis ?

bob654321 — Fri, 10 Jan 2020 03:30:47 GMT

It worked for the current selected year ,month and quarter. How to write the same expression for the previous quarter. I'm not sure what is wrong with this expression ?

count({<quarter={"<=$(vquarter) >=$(=$(vquarter)-1)"}>} distinct ID) Where vquarter = Max(quarternum)

Re: How to include the selected months in the set analysis ?

Arthur_Fong — Fri, 10 Jan 2020 03:45:21 GMT

Maybe try:

count({<quarter={">=$(=$(vquarter)-1)<=$(vquarter) "}>} distinct ID) Where vquarter = Max(quarternum)

Re: How to include the selected months in the set analysis ?

bob654321 — Fri, 10 Jan 2020 04:34:55 GMT

I tried your expression and I'm seeing the data for only current quarter selected in the listbox. It is not displaying the data for the previous quarter.

Re: How to include the selected months in the set analysis ?

Brett_Bleess — Mon, 10 Feb 2020 21:14:34 GMT

Bob, have a look at the following Design Blog post, might provide some further insight on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett