topic set in QlikView

set

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

how do we include greater than today into below set analysis ,

=count({<[Level]={'N'},

[Gate={2}>}[customer])

Regards

Re: set

Anil_Babu_Samineni — Wed, 16 Aug 2017 10:27:07 GMT

May be this?

=count({<Level={'N'}, Gate={2}, DateField = {"=DateField > Today()"}>}[customer])

Re: set

Anonymous — Wed, 16 Aug 2017 10:27:58 GMT

count({<

[Level]={'N'},

[Gate]={2},

YOURDATEFIELD={">=$(=date(today()))"}

>}[customer])

Re: set

srishsum2017 — Wed, 16 Aug 2017 10:28:50 GMT

Today means the current date so how you compare by the today, because either somebody want data of today or previous days....so please first clear your question...

other wise expression for greater than is-

=countt({<Date={'>=Today()'},[Level]={'N'},[Gate]={2}>}[customer])

Re: set

Anonymous — Wed, 16 Aug 2017 10:31:55 GMT

I think you can't use the syntax like that, even you do it like Anil or like me ...

Re: set

srishsum2017 — Wed, 16 Aug 2017 10:38:00 GMT

I am just giving an example how to use greater than in set analysis, other wise the best practice to store your dates which you want in variables, then use it.