Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
Thanks it worked..
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..