Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nevilledhamsiri
Valued Contributor

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

Re: Set Expression with < >

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)

6 Replies

Re: Set Expression with < >

May be this for the first condition

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

Re: Set Expression with < >

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
Valued Contributor

Re: Set Expression with <  >

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.

Re: Set Expression with <  >

Both meaning... one which meets this condition

(UNDER_OVER_PROVISION + MONTHS_PROVISION) < 500000

and

MONTHS_PROVISION > 1000 and MONTHS_PROVISION < 2000000

Highlighted
nevilledhamsiri
Valued Contributor

Re: Set Expression with <  >

Thank Sunny,

Now I can build up this to includes different requirements!

Regds

Neville   

Re: Set Expression with <  >

cool

Community Browser