Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am new to qlik and have been struggling to show just months for current year in X-axis of Combo chart.
I have a Combo chart where dimension is month and I have all the measures calculated to default to current year only.
SUM({$<Year={$(=MAX(Year))}>}Sales)
I have around 7 measures.. I have set all to current year only.
But in Combo chart, in X axis, all months are displayed from Jan to Dec,,, I want to see only the months for 2020 or max year.
Appreciate if someone could help.
Do you have other expressions in the chart? I am guessing you do because you mentioned a combo chart... are you using this same set analysis in all your expressions or not?
Thanks Sunny for looking into the question.. Yes I do have multiple measures and I am using set analysis for all expressions that is defaulted to current year. This is the one I used SUM({$<Year={$(=MAX(Year))}>}Sales) but just changed the measure names..
I have another sheet in the same app that has a Year filter. But Combo chart is in another sheet within same app. I am guessing that Year filter is being applied to the combo chart as well.
So if that is the case, I need to restrict that combo chart does not look at Year (Year from Date dim) filter.
Let me know how to proceed. Thanks again!!
So, you don't want Year filter on another sheet to impact year on this sheet?
yes please. You are right..