topic Re: Text Object showing detail values in QlikView

Text Object showing detail values

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 29 Aug 2017 12:23:39 GMT

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

sunny_talwar — Tue, 29 Aug 2017 12:49:54 GMT

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 — Tue, 29 Aug 2017 13:50:51 GMT

Hi Sunny,

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

sunny_talwar — Tue, 29 Aug 2017 14:03:49 GMT

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 — Tue, 29 Aug 2017 14:09:58 GMT

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 — Tue, 29 Aug 2017 14:11:03 GMT

Great!!

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

Best,

Sunny