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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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!