topic Re: Hide column if null in QlikView

Hide column if null

Thu, 05 Nov 2015 09:54:09 GMT

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?

Re: Hide column if null

Thu, 05 Nov 2015 13:15:40 GMT

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?

Re: Hide column if null

tamilarasu — Fri, 06 Nov 2015 02:26:48 GMT

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.

Re: Hide column if null

sasikanth — Fri, 06 Nov 2015 06:08:00 GMT

HI,

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

see below image

Re: Hide column if null

Fri, 06 Nov 2015 06:45:13 GMT

Thanks, works flawless

Re: Hide column if null

himanshi — Fri, 06 Nov 2015 11:19:44 GMT

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

Re: Hide column if null

sujit_nath — Wed, 11 Dec 2019 09:51:53 GMT

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/highlight/false#M71480