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

Percentage using calculated field

Hi

I wanted to divide the Grand Total divided by Personal Total.The same has to be repeated for the remaining rows also. plz suggest?

I Capture.PNG

17 Replies
Chanty4u
Esteemed Contributor III

Re: Percentage using calculated field

what do you want to show?

suryajegan
Contributor

Re: Percentage using calculated field

Hi Chanty

I want the Percentage of the Pivot Grand Total(i.e 48261) divide by PERSONAL(i.e 21021) and so on....

the same concept for the remaining PERSONAL,IRA & OTHER Category.

Chanty4u
Esteemed Contributor III

Re: Percentage using calculated field

try this

simple way

sum(Value2)/ sum(total Value1)

suryajegan
Contributor

Re: Percentage using calculated field

what is value 2 and value 1 in this case.

Capture.PNG

Chanty4u
Esteemed Contributor III

Re: Percentage using calculated field

suryajegan
Contributor

Re: Percentage using calculated field

I have created the rows by using the calculated field(i.e PERSONAL,IRA,OTHER etc).So I am looking for the division between those calculated fields as I mentioned before.plz suggest

giakoum
Honored Contributor II

Re: Percentage using calculated field

You have been given the answer already:

Divide your expression with the same expression just adding the total identifier

OmarBenSalem
Esteemed Contributor

Re: Percentage using calculated field

It would be sum(total yourExpression) / sum( total <"Account Type..">yourExpression)

OmarBenSalem
Esteemed Contributor

Re: Percentage using calculated field

If you want it to only be diveded by the value of personal and be propaged to every single row:

sum(total yourExpression) / sum( total {<"Account Type.."={'Personal'}>}yourExpression)