Set analysis with amount greater than 1

[amita1621]

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?

[swuehl]

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)

[amita1621]

Thanks it worked..

[amita1621]

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