Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ecems
Contributor
Contributor

% (percentage) of column in pivot

I want to calculate %  in pivot but i couldnt. 

I tried

Count / TOTAL (Count)

Count / TOTAL (<CountFieldName>Count) but they dont work.

For ex. in the higlighted cell, i want to see 9874 / 314780 --> %3,1

Could you please help me?

Thanks

I triedQlik2.PNG

 

 

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Specialist II
Specialist II

As follows

Count(Adet)/Count(TOTAL Adet)

View solution in original post

5 Replies
BrunPierre
Specialist II
Specialist II

Try with the actual field name.

=Count(IDs)/Count(TOTAL IDs)

ecems
Contributor
Contributor
Author

Hi;

should ı write IDs?  or instead of IDs what should I write?

 

thanks a lot

BrunPierre
Specialist II
Specialist II

Replace IDs with the actual field name.

ecems
Contributor
Contributor
Author

Field name is "Adet"; I tried Adet / TOTAL Adet but it doesnt work.

BrunPierre
Specialist II
Specialist II

As follows

Count(Adet)/Count(TOTAL Adet)