Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Does anybody have any idea of how to solve this?
Thanks for your help!
/Helena
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:
[COG Month]=
-Rob
Thank you for your answers!
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...)
/Helena