Text Object showing detail values

[Rajesh]

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

[Clever_Anjos]

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

[sunny_talwar · Accepted solution]

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]

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]

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