topic Re: Set analysis with amount greater than 1 in QlikView

Set analysis with amount greater than 1

amita1621 — Fri, 09 Feb 2018 12:44:59 GMT

I have amount which i need to split as '>1'as Reinsurance Receivable and '<1'as Reinsurance Payable.

Now i am using the same expression for both,Sum have to be applied on USD Amount and has to be differentaited by greater than 1 and less than1.

sum({<[Flag]={'Debt'},

Period={'4q 2017','3Q 2017','2Q 2017','1Q 2017','4Q 2016','3Q 2016','2Q 2016','1Q 2016' ,'4Q 2015', '3Q 2015','2Q 2015','1Q 2015'}>}[USD Amount]/1000)

How can we do this?

Re: Set analysis with amount greater than 1

swuehl — Fri, 09 Feb 2018 12:49:16 GMT

Not quite sure I understand your request.

If you want to filter your USD Amount values on a symbol base, you can use a set expression like

sum({<[Flag]={'Debt'}, [USD Amount] = {">1.0"},

Period={'4q 2017','3Q 2017','2Q 2017','1Q 2017','4Q 2016','3Q 2016','2Q 2016','1Q 2016' ,'4Q 2015', '3Q 2015','2Q 2015','1Q 2015'}>}[USD Amount]/1000)

resp. for payable

sum({<[Flag]={'Debt'}, [USD Amount] = {"<1.0"},

Period={'4q 2017','3Q 2017','2Q 2017','1Q 2017','4Q 2016','3Q 2016','2Q 2016','1Q 2016' ,'4Q 2015', '3Q 2015','2Q 2015','1Q 2015'}>}[USD Amount]/1000)

Re: Set analysis with amount greater than 1

amita1621 — Fri, 09 Feb 2018 13:09:15 GMT

Thanks it worked..

Re: Set analysis with amount greater than 1

amita1621 — Thu, 15 Feb 2018 06:28:02 GMT

Hi,

Actually in excel when i am dividing the value so i am using 3 fields(Period, reinsurer , Reinsured code)

and from that using sim ifs it is calulcated >1 and <1 , same implication is qlikview has to be done.

I hope this will help..