Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunsets4u
Contributor II
Contributor II

Display All Dimension Values Regardless of Selection

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

Labels (2)
4 Replies
jochem_zw
Employee
Employee

Is option include Zero Values set to on?

 

2020-01-16 23_21_40-Microsoft Edge.png

 

sunsets4u
Contributor II
Contributor II
Author

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,

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

sunsets4u
Contributor II
Contributor II
Author

Hi Rob,

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

Blessings,