Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
hi!
uncheck this
Hey, thank for your response.
But when i uncheck these cases, a new column appears.
How can i hide it please ?
Thanks in advance,
Cocalero
for dimension T in your table should check "Supress when value is null"
and Job_title - uncheck
Sorry, but I don't understand.
My settings here:
Cocalero
can u share a sample?
I'm sorry but i can't, however i can share some screenshot.
for dimension Type check Supress when Value is Null
on screenshot this position is unchecked, so, just check it