Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

always display values of dimension despite the current selection

Hello

I got a pivot table in which the dimension is a column from a parent table and the expressions are from the child table

not all the columns of the parent table have related values in the child table (per year)

what I want is display all existing values of the dimension column even if there is no data in the child table

kind of a left join but without really making a left join

is this possible?

I can walk on water when it freezes
1 Reply
erichshiino
Partner - Master
Partner - Master

You can play with some chart properties:

- at the dimensions tab: use the show all values

- at the presentation tab uncheck supress zero-values

Hope this helps,

Erich