Disconnect List Box from Chart

[#1]

Hello,

I have a chart showing Units sold and as dimension I have YearMonth e.g. 1601, 1602....

I have two list boxes in the sheet for time dimensions, Year and Month. How can i disconnect Month from my Unit sold chart? If I select "1" (representing January") i still want my chart to display all month.

My expressions are currently:

=SUM({<$(vSetUnitsSold), TimeType = {"Act"}>}Amount)

=SUM({<$(vSetUnitsSold), TimeType = {"Target"}>}Amount)

I was searching in the forum and the solution explained was to add {<Month =} e.g. sum({<Month = >}Amount)

I try to rewrite the expression to

=SUM({<Month=>}, {<$(vSetUnitsSold), TimeType = {"Act"}>}Amount)

but that does not work as no result are then being displayed.

What am I doing wrong?

Thank

[sunny_talwar · Accepted solution]

The expression you have tried is not the right syntax, the right one would something like this

=Sum({<$(vSetUnitsSold), TimeType = {"Act"}, Month=>} Amount)

=Sum({<$(vSetUnitsSold), TimeType = {"Target"}, Month=>}Amount)

[#3]

Hello,

Thanks for your quick respons. That solved the problem. However a new issue appeared...

If I select a single month in the list box e.g. 9. that month will be shown last in in the graph.

1601, 1602, 1603....1612, 1609

For my YearMonth dimension i have "MonthID" as sort order where monthID is 1 for the first YearMonth in the dataset.

How do I fix so that YearMonth is displayed in the right order?

[sunny_talwar]

Try this for the sort order expression

Only({1} MonthID)

[#5]

You are great Sunny! I now works perfectly!

I am creating my first application with no previous experince in building advanced BI solutions except form some simple models in Powerquery/powerpivot so I am really greatful for your help. I've found lots of good stuff here in the forum.

[sunny_talwar]

That is awesome... I am glad you are getting to learn a lot from all of us here. I hope you will contribute in the future

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny