Hide column if null

[#1]

Hi, I want to hide a column if there is no values in it based on a condition. My chart looks like:

Question1	Question2	Question3	Question4
2	3	-	5
3	7	-	1

Based on selected date there is no answers for Question3, and I then want to hide it so it looks like

Question1	Question2	Question4
2	3	5
3	7	1

But if I choose a date where Quesion3 have values I want it to be shown again.

Is that possible with a condition?

[#2]

I change me to this layout, might be easier:

Month	Question1	Question2	Question3	Question4
Jan	3	1	-	4
Feb	4	5	-	3
Total:	7	6	-	7

So if "Total:" for Question is - (null) the column will be hidden to:

Month	Question1	Question2	Question4
Jan	3	1	4
Feb	4	5	3
Total:	7	6	7

Possible?

[tamilarasu · Accepted solution]

Hi Niklas,

You can use conditional enable option for your expressions like below.

FYI, You can also conditionally show any dimensions like below.

Check the attachment and let me know.

[sasikanth]

HI,

If you go for Straight table there is an option conditional to show / hide Exp  ,

see below image

[#5]

Thanks, works flawless

[himanshi]

hiii,

  there is an option in chart properties' dimension tab if you want a dimension to suppress null values you can check the option of suppress when value is null.

regards,

Himanshi

[sujit_nath]

Does not work for me.. Is it not possible to achieve this if we have calculated label and calculated definition for the expression.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Hide-columns-in-pivot-table/m-p/1655165...