topic Re: Colums not displayed on Pivot Table in QlikView

Colums not displayed on Pivot Table

Anonymous — Mon, 21 Mar 2016 12:50:48 GMT

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.

Re: Colums not displayed on Pivot Table

Digvijay_Singh — Mon, 21 Mar 2016 13:11:34 GMT

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

Re: Colums not displayed on Pivot Table

t_chetirbok — Mon, 21 Mar 2016 13:13:46 GMT

hi!

uncheck this

Re: Colums not displayed on Pivot Table

Anonymous — Mon, 21 Mar 2016 14:56:15 GMT

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

Re: Colums not displayed on Pivot Table

t_chetirbok — Mon, 21 Mar 2016 16:43:38 GMT

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

and Job_title - uncheck

Re: Colums not displayed on Pivot Table

Anonymous — Mon, 21 Mar 2016 16:49:06 GMT

Sorry, but I don't understand.

My settings here:

Cocalero

Re: Colums not displayed on Pivot Table

Chanty4u — Mon, 21 Mar 2016 17:38:38 GMT

can u share a sample?

Re: Colums not displayed on Pivot Table

Anonymous — Mon, 21 Mar 2016 17:43:17 GMT

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

Re: Colums not displayed on Pivot Table

t_chetirbok — Mon, 21 Mar 2016 18:53:15 GMT

for dimension Type check Supress when Value is Null

Re: Colums not displayed on Pivot Table

t_chetirbok — Mon, 21 Mar 2016 20:03:23 GMT

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