Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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] )