Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

expression for filter

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

2 Solutions

Accepted Solutions
lironbaram
Partner
Partner

hi

you can use this

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

View solution in original post

everest226
Creator III
Creator III
Author

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

View solution in original post

2 Replies
lironbaram
Partner
Partner

hi

you can use this

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

View solution in original post

everest226
Creator III
Creator III
Author

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

View solution in original post