Does anybody know if there is a bug in QlikView 9 in set analysis? I am trying to create a chart that should show current sales year-to-date depending on which month I select. I.e. if I choose may-18, the chart should show the sales year-to-date until may-18.
I am using the following expression:
(sum({$<MonthID = {"<=$(=Max(MonthID))"},[COG Year] = {$(=Max([COG Year]))}>} [COG Max per Month]))*sum({$<MonthID = {"<=$(=Max(MonthID))"},[COG Year] = {$(=Max([COG Year]))}>} SalesQuantityCU)/Scale
It works when I select a year, but when I select a month, the chart only shows the sales for the selected month.
You are still on qlikview 9? Wow. I checked the one of the set analysis (replacing with my own columns ) and it works correctly. Did you test the document on a later version desktop? try splitting the the 2 set analysis into separate text objects as well Another possibility is adding single quotes to year set analysis {'$(=Max([COG Year]))'} good luck
QlikView 9 is no longer supported, but I think the problem is in your expression. If you allow the user to select a month, you will have to ignore that selection. Like:
Yes, it was an error in my expression. I had an if-statement (that I had deleted in my example) in the set-analysis and that caused the problem. (And I know that it would be a great idea to upgrade from QlikView 9...)
