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

Text Object showing detail values

Hi All,

In text object showing detail values, need to show sum up values.

in pivot table its showing as expected values but not in text object showing detail values.

if i select filter its showing correct value.

Expression in text object: =Num(Count({<nps_value = {'Detractors'},Value_Experience = {'V'}>}nps_value)/(Count(nps_value)),'#.#0%')

can any one please suggest.

Thanks

Rajesh

1 Solution

Accepted Solutions
sunny_talwar

What all are you dimensions in the pivot table? Assuming it is Dim1, Dim2, Dim3... you can try this

=Num(

Sum(Aggr(

Count({<nps_value = {'Detractors'},Value_Experience = {'V'}>}nps_value)/(Count(nps_value))

,Dim1, Dim2, Dim3))

,'#.#0%')

View solution in original post

6 Replies
Clever_Anjos
Employee
Employee

Could you describe (screenshots are welcome) what is your desired output?

sunny_talwar

What all are you dimensions in the pivot table? Assuming it is Dim1, Dim2, Dim3... you can try this

=Num(

Sum(Aggr(

Count({<nps_value = {'Detractors'},Value_Experience = {'V'}>}nps_value)/(Count(nps_value))

,Dim1, Dim2, Dim3))

,'#.#0%')

Rajesh
Creator II
Creator II
Author

Hi Sunny,

with u r expression its showing 100% in text box.

sunny_talwar

What do you want to see? Avg of the values in your table?

=Num(

Avg(Aggr(

Count({<nps_value = {'Detractors'},Value_Experience = {'V'}>}nps_value)/(Count(nps_value))

,Dim1, Dim2, Dim3))

,'#.#0%')

Rajesh
Creator II
Creator II
Author

Thank you very much Sunny

its working as expected.

I was also used  Aggr function earlier but there a syntax error.

Regards

Rajesh

sunny_talwar

Great!!

Please close the thread down by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny