topic Re: expression for filter in QlikView

expression for filter

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

I have a chart expression to display status which are active and process only

My expression is

=if(Match([Status],'Active','Process'), Contract)

which works fine now i want to add and statement to give me record which active date are grater than 5-31-2015 and only this activate date rules apply when Field [Type] value is C

Re: expression for filter

lironbaram — Wed, 07 Nov 2018 14:53:25 GMT

you can use this

=if(Match([Status],'Active','Process') and [active date]>date('5/31/2015'), Contract)

Re: expression for filter

everest226 — Wed, 07 Nov 2018 15:12:43 GMT

your expression works fine i just forgot to mention that only in a field name [Contract Category] which value is C that active date rule apply .

Thanks