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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Set Expression

I have created the following set expression and it is working fine.

sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]={"$(=Only([R_MONTH]))"}>} [PREMIUM] )

I have two other  dimensions in my chart 'TO_MONTH' and 'TYPE' I want to modify the above expression to extract data where I want fulfill following conditions

1     R_YEAR] = {"$(=Only([R_YEAR]))"

2     [R_MONTH] not equal to TO-MONTH

3     TYPE='F'

Pls help me to rewrite the Set expression 

1 Solution

Accepted Solutions
Not applicable

sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}>} [PREMIUM] )

View solution in original post

1 Reply
Not applicable

sum( {1<[R_YEAR] = {"$(=Only([R_YEAR]))"},[R_MONTH]-={"$(=Only([TO-MONTH]))"},TYPE={'F'}>} [PREMIUM] )