Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vineetadahiya12
New Contributor III

I am trying to calculate % based on subtotals in pivot table in Qliksense

  In pivot table I will have Country , State  Line Amt. I need to show the % using subtotal values in qliksense

CountryStateLine Amt%

India

Delhi3030% (  (30/100)*100
Punjab4040%
Haryana3030%
USLA2525%
CA2525%
New York5050%
Total200--

I am looking something similar to  Line Amt / Sum(Line Amt) Group By Country.

2 Replies

Re: I am trying to calculate % based on subtotals in pivot table in Qliksense

Try this:

Sum([Line Amt])/Sum(TOTAL <Country> [Line Amt])

Varsha
New Contributor

Re: I am trying to calculate % based on subtotals in pivot table in Qliksense

I have a requirement to find percentage of subtotals.
Like in above example, I want to get sum(line amt)/ sum (line amount for all the countries),
((total for India)/(total for India and US))*100