Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
amita1621
Contributor III
Contributor III

Set analysis with amount greater than 1

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?

3 Replies
swuehl
MVP
MVP

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
Contributor III
Contributor III
Author

Thanks it worked..

amita1621
Contributor III
Contributor III
Author

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.

Capture6.PNGCapture7.PNGCapture8.PNG

I hope  this will help..