topic Re: Help with multiple conditional expression based on user selection in QlikView

Help with multiple conditional expression based on user selection

Mon, 17 Apr 2017 15:49:23 GMT

I have the field "month", which has values 1-12. I have another field, "num_mondays", which looks at each month and has the proper number of Mondays (4 or 5).

I have simple expressions in a pivot chart where I need to divide them by the number of Mondays, depending on the month selection.

For example, one expression I have is called Uploads YTD, and it's simply: sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits)

I don't know how to divide that by num_mondays, based on user selection of month in listbox.

Re: Help with multiple conditional expression based on user selection

Anonymous — Mon, 17 Apr 2017 15:54:37 GMT

why not sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits) /num_mondays if you are using month as dimension??

Re: Help with multiple conditional expression based on user selection

Mon, 17 Apr 2017 16:02:09 GMT

I'm not using month as a dimension, I'm using state as a dimension

Re: Help with multiple conditional expression based on user selection

Anonymous — Mon, 17 Apr 2017 16:26:39 GMT

Can you please share a sample if sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits) /num_mondays is not working??