Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Set Expression with < >

Hi Experts,

Please help me to achieve following out put!

As for the 1st expression, if I am to say MONTH_PROVISION> 1000 & <2000000, how it could be included in to this set expression?

As for the 2nd expression, if  I am to combine  MONTHS_PROVISION +UNDER_OVER_PROVISION & to say if both   MONTH_PROVISION  & UNDER_OVER_PROVISION added together & resulted figure if <500000,then what the outcome is

SUM({<CLASS_CODE-={'MC','M4','M3','CH','PP'},MONTHS_PROVISION={"=MONTHS_PROVISION<2000000"}>}MONTHS_PROVISION)

SUM({<CLASS_CODE={'MC','M4','M3','CH','PP'},UNDER_OVER_PROVISION={"=UNDER_OVER_PROVISION <2000000"}>}UNDER_OVER_PROVISION)

Many Thanks

Neville

1 Solution

Accepted Solutions
sunny_talwar

And may be this for the second provision

Sum({<CLASS_CODE={'MC','M4','M3','CH','PP'}, CLAIM_NO = {"=(UNDER_OVER_PROVISION + MONTHS_PROVISION) < 500000"}>}UNDER_OVER_PROVISION)

View solution in original post

6 Replies
sunny_talwar

May be this for the first condition

Sum({<CLASS_CODE -= {'MC','M4','M3','CH','PP'}, MONTHS_PROVISION = {">1000<2000000"}>} MONTHS_PROVISION)

sunny_talwar

And may be this for the second provision

Sum({<CLASS_CODE={'MC','M4','M3','CH','PP'}, CLAIM_NO = {"=(UNDER_OVER_PROVISION + MONTHS_PROVISION) < 500000"}>}UNDER_OVER_PROVISION)

nevilledhamsiri
Specialist
Specialist
Author

Thank Sunny, This is ok. Please also help me to find out an answer if both expressions are added together & make it subject to a condition such as one that I have informed.

sunny_talwar

Both meaning... one which meets this condition

(UNDER_OVER_PROVISION + MONTHS_PROVISION) < 500000

and

MONTHS_PROVISION > 1000 and MONTHS_PROVISION < 2000000

nevilledhamsiri
Specialist
Specialist
Author

Thank Sunny,

Now I can build up this to includes different requirements!

Regds

Neville   

sunny_talwar

cool