Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajesh
Creator II
Creator II

How to show Pivot table expression total percentage in text object ?

Hi All,

I am trying to show Pivot table expression total percentage in text object, but its showing 100% instead of 32%, plz suggest.

plz see below lmage

Capture.PNG

Thanks

Rajesh

1 Solution

Accepted Solutions
Rajesh
Creator II
Creator II
Author

Thank you Anjos,

its working now missed the brackets earlier

=Num(Count({<[NPS catagories] = {'Detractors'}>}[NPS catagories])/(Count([NPS catagories])),'#.#0%')

View solution in original post

10 Replies
Clever_Anjos
Employee
Employee

Which expression is [NPS Catagories]?

Rajesh
Creator II
Creator II
Author

its Count(NPS Categories)/Count( Total NPS Categories) in pivot table

Clever_Anjos
Employee
Employee

And you want to show only for Detractors?

Count({<[NPS Categories]={"Detractors"}>}[NPS Categories])/Count([NPS Categories])

Rajesh
Creator II
Creator II
Author

yes Anjos,

but your expression is not working in text object

Clever_Anjos
Employee
Employee

Whats the result?

Rajesh
Creator II
Creator II
Author

showing Zero

sunny_talwar

May be this

Sum({<[NPS Categories]={"Detractors"}>} Aggr(Count([NPS Categories])/Count(TOTAL [NPS Categories]), Type, [NPS Categories]))

sunny_talwar

Or this

Sum({<[NPS Categories]={"Detractors"}>} Aggr(Count({<[NPS Categories]={"Detractors"}>}[NPS Categories])/Count(TOTAL [NPS Categories]), Type, [NPS Categories]))

Rajesh
Creator II
Creator II
Author

Thank you Anjos,

its working now missed the brackets earlier

=Num(Count({<[NPS catagories] = {'Detractors'}>}[NPS catagories])/(Count([NPS catagories])),'#.#0%')