How to hide Null value column Expresssions

[#1]

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

[MayilVahanan]

HI

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.

[jagan]

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.

[#4]

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

[#5]

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

[himanshi]

hi avinash,

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

[tamilarasu · Accepted solution]

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.

[jagan]

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

[Anonymous]

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

[sujit_nath]

 trying to implement similar solution. Does not work 😞

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