topic Re: How do I create a greater than 'date' expression? in QlikView

How do I create a greater than 'date' expression?

Wed, 25 Nov 2020 16:16:04 GMT

Rookie post:

I've created a straight table with 7 columns. One column is 'Expiration Date'. I only want to only show fields that are greater than '01/01/2016' without having to click on a button or filter list?

Can it be hard coded in as a set analysis expression?

TIA.

Re: How do I create a greater than 'date' expression?

Anonymous — Fri, 19 Aug 2016 11:19:24 GMT

you can use set Analysis

{<[Expiration Date]={'>=01/01/2016'}>}

be sure that the data is exactly in same Format as your field

Re: How do I create a greater than 'date' expression?

Fri, 19 Aug 2016 11:24:39 GMT

Thanks for your quick reply.

That's what I originally thought and tried. But I'm obviously missing something in the process...

Do I add it as a calculation condition or a sorting expression or another way?

Also do I need to add 'Sum' to the beginning?

Re: How do I create a greater than 'date' expression?

Anonymous — Fri, 19 Aug 2016 12:31:18 GMT

that's right

you Need a calculation option like

=sum({<[Expiration Date]={'>=01/01/2016'}>}yourvalue)

or Count or ..

you may add additional set Analysis parts as well