Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

trying to measure 2 conditions

hi,

count({<[Year]={$(=max([Year])-1)}>}EMP_STATUS='A')

in the above statement i m trying to count emp_status value A for perivous year .

is it correct ?

12 Replies
OmarBenSalem

and here is one thread in which I tried to explain step by step some time related set expressions:

YTD, MTD issue

hope that this will be helpful

Anonymous
Not applicable
Author

thanks alot

Anonymous
Not applicable
Author

thanks alot