Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try:
Count({< fnl_determ_qtr={$(vSelectedQuarter)}>}DISTINCT ID))
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)
Maybe try:
count({<quarter={">=$(=$(vquarter)-1)<=$(vquarter) "}>} distinct ID) Where vquarter = Max(quarternum)
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.
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