Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik gurus,
Is there a way to display all dimension values regardless of any month selection?
I've checked some posts but they all involve measures:
https://community.qlik.com/t5/Qlik-Sense-App-Development/Qlik-Sense-Show-All-Dates-When-Selecting-a-...
https://community.qlik.com/t5/New-to-Qlik-Sense/Show-dimension-ignore-selection/td-p/1035728
My app has MTD and YTD volume and budget. I have filter pane for month (with field settings of "Always one selected value"). As a result, my graph now only shows one month.
From what I've gathered from the forum, you'd need to use set analysis to display all values regardless of user selection = SUM({1} Actuals)
To disregard specific dimensions = Sum({$< FiscalPeriod ,FiscalYear >} Actuals)
But how can you display all dimension and not measures?
Appreciate your time.
Blessings,
Louis
Is option include Zero Values set to on?
Hi Jochem,
Thanks for your suggestion.
The zero values is turned on.
There's a work around with my issue by selecting all the previous months to the selected month to display months.
Possibly I should take this issue in another angle like by grouping my fiscal periods?
Ideally, users can select a desired month (e.g. fiscal year starts on July, if a user selects December, it would display July to December months).
Blessings,
If you use the set analysis in your measure, it should pull in all dimension values.
-Rob
Hi Rob,
What if you're using the field as a Filter Pane? Like it only shows the field without the measure?
Blessings,