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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Colums not displayed on Pivot Table

Hello,

I am an beginner on QlikView and I have a problem on pivot table. I would like to display values by category, but when there are no values, some columns are not displayed.

How can I avoid this?

Thanks in advance,

Cocalero.

Labels (1)
9 Replies
Digvijay_Singh
MVP
MVP

Do you mean no values of columns against a value of category, then you may need to check Show All Values in Dimension tab to see all categories in the table

t_chetirbok
Creator III
Creator III

hi!

uncheck this

Anonymous
Not applicable
Author

Hey, thank for your response.

But when i uncheck these cases, a new column appears.

Capture.PNG

How can i hide it please ?

Thanks in advance,

Cocalero

t_chetirbok
Creator III
Creator III

for dimension T in your table should check "Supress when value is null"

and Job_title - uncheck

Anonymous
Not applicable
Author

Sorry, but I don't understand.

My settings here:

Capture.PNG

Capture1.PNG

Cocalero

Chanty4u
MVP
MVP

can u share a sample?

Anonymous
Not applicable
Author

I'm sorry but i can't, however i can share some screenshot.

t_chetirbok
Creator III
Creator III

for dimension Type check Supress when Value is NullБезымянный.png

t_chetirbok
Creator III
Creator III

on screenshot this position is unchecked, so, just check it