topic Re: How to hide Null value column Expresssions in QlikView

How to hide Null value column Expresssions

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

In above image straight table chart we have two column expressions values. If any of expression column doesnt have value then the whole row should be hide. Here we have calculated dimension as YEAR.

Please let me know this. jagan‌ MayilVahanan‌

Thanks

Avinash

Re: How to hide Null value column Expresssions

MayilVahanan — Thu, 10 Dec 2015 09:14:30 GMT

Try like this

Exp1:

= if(Isnull(Exp1) or isnull(Exp2), Exp1) or if(Exp1 <> 0 or Exp2<> 0, Exp1)

Exp2:

= if(Isnull(Exp1) or isnull(Exp2), Exp2)

Check Suppress Null Values check box.

Re: How to hide Null value column Expresssions

jagan — Thu, 10 Dec 2015 09:20:28 GMT

Hi Avinash,

Try like this

Expression1:

If(Expression1 > 0 AND Expression2 > 0, Expression1)

Expression2:

If(Expression1 > 0 AND Expression2 > 0, Expression2)

Example:

If(Sum(Measure1) > 0 AND Sum(Measure2) > 0, Sum(Measure1))

If(Sum(Measure1) > 0 AND Sum(Measure2) > 0, Sum(Measure2))

Select Supress zero values and Null values option in Presentation tab.

Hope this helps you.

Regards,

jagan.

Re: How to hide Null value column Expresssions

Thu, 10 Dec 2015 10:43:14 GMT

hi,

Thanks for your reply.

I tried with the above condition but it is not hiding whole row.

Please have look at this image

First column is dimension year and other all columns are expressions and i want to hide whole row when there is any null in the last two columns expressions

Re: How to hide Null value column Expresssions

Thu, 10 Dec 2015 10:43:31 GMT

hi,

Thanks for your reply.

I tried with the above condition but it is not hiding whole row.

Please have look at this image

First column is dimension year and other all columns are expressions and i want to hide whole row when there is any null in the last two columns expressions

Re: How to hide Null value column Expresssions

himanshi — Thu, 10 Dec 2015 10:47:34 GMT

hi avinash,

Try suppress when value is null option in chart properties presentation tab.

Re: How to hide Null value column Expresssions

tamilarasu — Thu, 10 Dec 2015 11:19:34 GMT

Hi Avinash,

Try,

Exp1 as

If(Len(Trim(Exp1))<>0 and Len(Trim(Exp2))<>0, Exp1)

Exp2 as

If(Len(Trim(Exp1))<>0 and Len(Trim(Exp2))<>0, Exp2)

Check the attachment.

Re: How to hide Null value column Expresssions

jagan — Thu, 10 Dec 2015 11:44:44 GMT

You have to use if in all expressions. If possible attach sample file.

Re: How to hide Null value column Expresssions

Anonymous — Thu, 10 Dec 2015 11:48:41 GMT

I dont think this would be possible becoz Year is having value from other expression as well

Re: How to hide Null value column Expresssions

sujit_nath — Tue, 10 Dec 2019 05:19:50 GMT

trying to implement similar solution. Does not work 😞

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