Bar Chart Rolling Month Set Analysis don't work

DeeePeee — Thu, 07 Nov 2019 09:17:36 GMT

Hi at all,

i have a issue or understanding problem in my bar chart. I have this following formel with expression:

Sum({<%_Key_Account={"ADDEDVALUE"},%_Key_Category={"ACTUAL"},DataMeasures={"PER"},YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -18), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"}>} DataValue)

For testing i created listboxes with the

%_Key_Account

%_Key_Category

DataMeasures

i selected the values like in the formel above. Everything worked fine, but when i deselect one of this listboxes which i want to filter in my formel, then the set analysis didn't work.

Can anyone help me?

Thanks

Re: Bar Chart Rolling Month Set Analysis don't work

DeeePeee — Thu, 07 Nov 2019 09:41:52 GMT

I found the solution which will work:

Sum({< %_Key_Account={"ADDEDVALUE"},%_Key_Category={"ACTUAL"},DataMeasures={"PER"},YearMonth ={">=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -18), 'MMM-YY')) <=$(=Date(addmonths(Max({<%_Key_Account={ADDEDVALUE},%_Key_Category={ACTUAL},DataMeasures={PER}>}YearMonth), -1), 'MMM-YY'))"}>} DataValue)/1000000

I must add the filter into the rolling filter

topic Re: Bar Chart Rolling Month Set Analysis don't work in QlikView

Bar Chart Rolling Month Set Analysis don't work

Re: Bar Chart Rolling Month Set Analysis don't work