topic Re: Hide Column based on Expression in QlikView

Hide Column based on Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table as below with record type as dimension.. I need to hide the rows which have no issue and display only the once with the issue. How can I achieve this.

Thanks in advance

Re: Hide Column based on Expression

vishsaggi — Mon, 15 Aug 2016 15:56:36 GMT

IS this a Straight table ? If yes,

In the Expression tab:

Check Enable conditional for that specific Column name (Issue)

Then write = Only(Issue) = 'No Issue'

Try this.

Re: Hide Column based on Expression

Mon, 15 Aug 2016 16:03:57 GMT

I tired it. The expression says " Bad Field Name(s): Issue.. Its not working..

Re: Hide Column based on Expression

Mon, 15 Aug 2016 16:08:52 GMT

and it s a straight table..

Re: Hide Column based on Expression

ecolomer — Mon, 15 Aug 2016 16:09:50 GMT

You can also, write this expression in the dimension:

=if(Issue <> 'No Issue', [Record Type])

and check option "Supress when is Null value"

Re: Hide Column based on Expression

vishsaggi — Mon, 15 Aug 2016 16:16:36 GMT

What is the field name for this No Issue value in the table ?

Re: Hide Column based on Expression

Mon, 15 Aug 2016 16:21:24 GMT

It is not a field in the table.. It is an expression defined based on this "=if([DM]-[Oats]<0,'Oats Not in DM', if([DM]-[Oats]>0,'DM Not IN Oats', if([DM]-[Oats]=0,'No Issue')))"..

Re: Hide Column based on Expression

vishsaggi — Mon, 15 Aug 2016 18:12:53 GMT

Can you try this?

Edit the expression for Issue Calculated column as below:

=if(DM - Oats < 0,'Oats Not in DM',

if(DM - Oats > 0,'DM Not IN Oats',

if(DM - Oats = 0, DUAL('No Issue', 0)

)))

-> Go to Presentation tab and Check Supress Zero values.

Re: Hide Column based on Expression

Mon, 15 Aug 2016 18:22:20 GMT

I tired it but it doesn't work either.. I tired it from the script side and pulled up only differences and populated the chart.

Re: Hide Column based on Expression

vishsaggi — Mon, 15 Aug 2016 18:39:37 GMT

Right, I need you to send me your sample app with scrambled data if any confidential information. I have populated based on the image you have sent and it worked fine at my end. Can you populate some sample data and send it pls ?

Re: Hide Column based on Expression

Mon, 15 Aug 2016 18:43:04 GMT

Sure will do.. Might take some time though.. thank you so much for your help..

Re: Hide Column based on Expression

Tue, 16 Aug 2016 02:16:44 GMT

Hi,

Hide a row in straight table

Re: Hide Column based on Expression

Anonymous — Tue, 16 Aug 2016 06:51:42 GMT

Hi Mohan,

Try with Set Analisys, YourIssueField -= {'No Issue'}

Regards!!

Re: Hide Column based on Expression

ecolomer — Wed, 17 Aug 2016 05:49:09 GMT

See this:

Hide a row in straight table

Re: Hide Column based on Expression

Anonymous — Wed, 17 Aug 2016 07:21:16 GMT

Hi Mohan,

I usually use a workaround method for this and that is using the same condition in all expressions.

In you case

if(Issue<>'No Issue', DM)

if(Issue<>'No Issue', Oats)

if(Issue<>'No Issue', DM-Oats)

if(Issue<>'No Issue', Issue)

Hope this helps.

Laxmi

Re: Hide Column based on Expression

Wed, 17 Aug 2016 12:33:14 GMT

Thanks every on for the reply...

Laxmi It's Working,Awesome....Thanks a lot