Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show all values of a dimension

Hello,

i have a issue database where i want to do the following in qv

I have 4 tables:

  • projects
  • status
  • priority
  • issues

now i have a pivot table and what i want to do is show alle values of status even if the project contains not all the status values.

is this possible?

if yes, how can i do it?

7 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

You can do it by checking show all values in dimension Tab

Not applicable
Author

thought so too, but for a dimension on the x as it works.... however a dimension on the y as I don't get it to work

Anonymous
Not applicable
Author

Did you try the "Show All Values" options in the Dimension tab?

Also uncheck the "Supress Zero-values" option on the Presentation tab.

vijay_iitkgp
Partner - Specialist
Partner - Specialist

In continuation to Dennis also check populate missing.

Not applicable
Author

I tried it,but no help.

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Can you please share  the pivot table

ToniKautto
Employee
Employee

Please attach a sample QVW of the chart and data you are working, to make it easier to evaluate and advise on.