topic Re: Need to hide the expression column in straight table in QlikView

Need to hide the expression column in straight table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am facing one issue in straight table is that, I have expression column wherever value is zero, I have to remove that column from straight table.

Could you please guide me.

Re: Need to hide the expression column in straight table

surendraj — Fri, 24 Feb 2017 09:03:23 GMT

Go to Properties-->Presentation-->Click on that column-->Enable(Hide column)

Re: Need to hide the expression column in straight table

avinashelite — Fri, 24 Feb 2017 09:05:42 GMT

Chart Properties >Presentation >hide

or you could go with conditional hide also in the expression tab

Re: Need to hide the expression column in straight table

surendraj — Fri, 24 Feb 2017 09:09:33 GMT

Yes @Avinash

or else

Enable conditional-->False() should also work.

Re: Need to hide the expression column in straight table

Fri, 24 Feb 2017 09:25:24 GMT

Hi,

Not manually, Some times there may be values. whenever zero is there the I need to hide that column automatically.

I think now clear.

In expression conditional part we have wrote already some condition to expression based on selection.

Thanks for reply.

Re: Need to hide the expression column in straight table

surendraj — Fri, 24 Feb 2017 09:34:37 GMT

Then Add another condition like

if(Your expression value >0,True(),False())

Re: Need to hide the expression column in straight table

Fri, 24 Feb 2017 13:10:18 GMT

Hi Surendra,

its working,

Thanks.

But there is a problem in dimension there is null value but I used suppress null value option but above condition how can I remove grouping with dimension.

i.e for dimension null value we have measure value so that is calculating, so I need to remove that value from expression.

Re: Need to hide the expression column in straight table

surendraj — Fri, 24 Feb 2017 13:55:50 GMT

i didn't get you...

please elabarate...!!