How to do Ratio Calculation in Qlik

narayanaqlik — Tue, 11 Sep 2018 07:11:46 GMT

Hi All,

i need to display some calculation like:

sum of Amount where country USA/ Sum of Amount where Country none USA based on reference ID's

Aggr(Sum({<Country={"USA"}>}Amount)/Sum({<Country-={"USA"}>}Amount),[reference ID]),

Aggr(Sum({<Country={"USA"}>}Amount),[Reference ID])/Aggr(Sum({<Country-={"USA"}>}Amount),[Reference ID])

i have written both the Expressions but didn't give the results

Note: in that report apport from reference Id, Name, Country,date fields are also there

Please suggest me any good expression

Thanks in Advance

topic How to do Ratio Calculation in Qlik in QlikView