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

not equal in set expression

I have following expression which is working fine

sum( {<R_YEAR=,R_MONTH=,[R_MONTH]= {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

But one I modify it in the following way it does not work

sum( {<R_YEAR=,R_MONTH=,[R_MONTH]-= {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

Pls help me write it correctly

11 Replies
upaliwije
Creator II
Creator II
Author

Dear Friends

Could you pls help me to rectify my expression

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Is there any selection you are doing which will impact the calculation?

If yes then those needs to be neglected in the set analysis I gave you.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!