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

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
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,