topic Set Expression with < > in QlikView

Set Expression with < >

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Expression with < >

sunny_talwar — Tue, 17 Apr 2018 15:03:43 GMT

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

sunny_talwar — Tue, 17 Apr 2018 15:05:44 GMT

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)

Re: Set Expression with < >

nevilledhamsiri — Tue, 17 Apr 2018 15:09:52 GMT

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

sunny_talwar — Tue, 17 Apr 2018 15:15:21 GMT

Both meaning... one which meets this condition

(UNDER_OVER_PROVISION + MONTHS_PROVISION) < 500000

and

MONTHS_PROVISION > 1000 and MONTHS_PROVISION < 2000000

Re: Set Expression with < >

nevilledhamsiri — Tue, 17 Apr 2018 15:27:34 GMT

Thank Sunny,

Now I can build up this to includes different requirements!

Regds

Neville

Re: Set Expression with < >

sunny_talwar — Tue, 17 Apr 2018 15:42:47 GMT

cool