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: 
francisvandergr
Partner - Creator II
Partner - Creator II

all possible values of dimension in pivot table

I have a question. I have a pivot table with 2 dimensions.

I wanna see always all possible values from my first dimension.

Is this possible and how ?

4 Replies
YoussefBelloum
Champion
Champion

Hi,

in pivot table, you can do this:

in the presentation tab => uncheck suppress NULL values

on the Dimensions tab => check display all the values

francisvandergr
Partner - Creator II
Partner - Creator II
Author

i have done this already

YoussefBelloum
Champion
Champion

Can you attach a sample app on which you can't display all the dimensions ?

Clever_Anjos
Employee
Employee

does your expression returns values to all needed combinations?