Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

show all values of a dimension

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

Not applicable

show all values of a dimension

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

dennisnet
Valued Contributor III

show all values of a dimension

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
Valued Contributor

show all values of a dimension

In continuation to Dennis also check populate missing.

Not applicable

show all values of a dimension

I tried it,but no help.

vijay_iitkgp
Valued Contributor

show all values of a dimension

Can you please share  the pivot table

Employee
Employee

show all values of a dimension

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

Community Browser