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: 
upaliwije
Creator II
Creator II

Date in Set Expression

In My attachment I have following dimension fields

R_Year,R_Month,To_Year, To_Month

when I select R_Year+2013 and R_Month=Jan

I want the following Results

To_Year=R_Year+2 and To_Month=R_Month  and Pol_Type='R'

I have written the following expression but it is not working

sum( {<[To_YEAR] = {$(=max([R_YEAR]+2))},POL_TYPE={'R'}>} [PREMIUM] )

Pls look into my attachment and correct it expression to suit my requirement

Thanks

1 Reply
MK_QSL
MVP
MVP

Try like below..

sum( {<[To_YEAR] = {'$(=Max(R_YEAR)+2)'},POL_TYPE={'R'}>} [PREMIUM] )