topic Re: Hide/Show Expression Columns using Conditional in QlikView

Hide/Show Expression Columns using Conditional

alexandergrando — Mon, 10 Jul 2017 21:54:44 GMT

Hello,

I have the following expression used in a straight table:

=If(EndDateOfOperation > Today(), If(Region = 'MISSING', 'Yes'))

I would like to hide the column that shows this expression if no expression results are 'Yes'. But I can't figure it out. Can anyone please help? Thanks.

Message was edited by: Alexander Grando

Re: Hide/Show Expression Columns using Conditional

Anonymous — Mon, 10 Jul 2017 22:49:31 GMT

in your conditional show expression try

count(distinct {NPRegion={'MISSING'}>}NPRegion)>0

Re: Hide/Show Expression Columns using Conditional

alexandergrando — Mon, 10 Jul 2017 22:56:18 GMT

Hi Wallo,

It appears that there is an error in your conditional expression according to QlikView. Please see attached screenshot. Also, the expression is not hiding a column that I know does not have any 'Yes' values.

Re: Hide/Show Expression Columns using Conditional

Anonymous — Mon, 10 Jul 2017 22:58:04 GMT

Sorry,. Should be

count(distinct {<NPRegion={'MISSING'}>}NPRegion)>0

Re: Hide/Show Expression Columns using Conditional

alexandergrando — Mon, 10 Jul 2017 23:03:30 GMT

Thank you!

Re: Hide/Show Expression Columns using Conditional

alexandergrando — Thu, 13 Jul 2017 16:18:32 GMT

Hi Wallo,

Upon closer examination, it looks like your expression is evaluating all rows in the app. But I need it just to evaluate those that are used in my straight table. Otherwise, I have expression columns showing up in my straight table that are blank. Is there any way to redo the conditional formula so that it only evaluates whether the result of the expression is 'Yes'?

Re: Hide/Show Expression Columns using Conditional

Anonymous — Thu, 13 Jul 2017 16:22:26 GMT

Can you share a sample app?

Re: Hide/Show Expression Columns using Conditional

alexandergrando — Thu, 13 Jul 2017 16:28:38 GMT

It will take me a bit of time to put one together due to privacy issues. Also, I forgot to mention that I altered my expression to:

=If(EndDateOfOperation > Today(), If(Region = 'MISSING', 'Yes'))

The problem with your conditional formula is that it is counting regions that have an EndDateOfOperation on any day. I need it to be restricted to where the EndDateOfOperation is greater than today.

Does that help at all?

Re: Hide/Show Expression Columns using Conditional

Anonymous — Thu, 13 Jul 2017 16:41:05 GMT

Haven't tested this but you can try

count(distinct {<EndDateOfOperation={'>$(=today())'}>}, NPRegion={'MISSING'}>}NPRegion)>0

Re: Hide/Show Expression Columns using Conditional

alexandergrando — Thu, 13 Jul 2017 16:44:21 GMT

Great! Thanks for bearing with me.

Re: Hide/Show Expression Columns using Conditional

Anonymous — Thu, 13 Jul 2017 16:51:50 GMT

No problem. Glad you got what you needed.