Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.

9 Replies
Digvijay_Singh

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