topic Re: Hide values from straight table when <1 in QlikView

Hide values from straight table when <1

Wed, 29 May 2013 13:54:34 GMT

I have a interval calculation in my expression:

=Interval(Date([SAMPLE.Verified Date],'DD-MM-YYYY')-Date([SAMPLE.Due Date],'DD-MM-YYYY'), 'D')

This gives sometimes negative results. And i want to hide everything under the vallue 1 from the table.

How to do this?

Re: Hide values from straight table when <1

jonathandienst — Wed, 29 May 2013 13:59:53 GMT

This should do it:

=Interval(If([SAMPLE.Verified Date] > [SAMPLE.Due Date], [SAMPLE.Verified Date] - [SAMPLE.Due Date]), 'D'))

Hope that helps

Jonathan

Re: Hide values from straight table when <1

Wed, 29 May 2013 14:06:59 GMT

Thanks a lot! This seem to work.

But i forget to mentiod i have 2 expressions and i want also to hide the values from the first expression when the results from the second expression are <1.

Re: Hide values from straight table when <1

Wed, 29 May 2013 14:13:17 GMT

Hi,

Try if((Interval(If([SAMPLE.Verified Date] > [SAMPLE.Due Date], [SAMPLE.Verified Date] - [SAMPLE.Due Date]), 'D')),Expression_1)

Rebeca