topic Re: Display All Dimension Values Regardless of Selection in App Development

Display All Dimension Values Regardless of Selection

sunsets4u — Sat, 16 Nov 2024 03:36:42 GMT

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-Dimension-Value/td-p/5864

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

Re: Display All Dimension Values Regardless of Selection

jochem_zw — Thu, 16 Jan 2020 22:24:39 GMT

Is option include Zero Values set to on?

Re: Display All Dimension Values Regardless of Selection

sunsets4u — Thu, 16 Jan 2020 23:20:16 GMT

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,

Re: Display All Dimension Values Regardless of Selection

rwunderlich — Fri, 17 Jan 2020 01:47:44 GMT

If you use the set analysis in your measure, it should pull in all dimension values.

-Rob

Re: Display All Dimension Values Regardless of Selection

sunsets4u — Fri, 17 Jan 2020 03:03:15 GMT

Hi Rob,

What if you're using the field as a Filter Pane? Like it only shows the field without the measure?

Blessings,