topic Re: Error in Calculated dimension in QlikView

Error in Calculated dimension

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

Hi All,

i am facing one issue that error in calculated dimension.

the expression is

Num(Num(Count({<nps_value = {'Promoter'}>}nps_value)/(Count(nps_value)),'#.#0%')

- Num(Count({<nps_value = {'Detractors'}>}nps_value)/(Count(nps_value)),'#.#0%'),'#.#0%')

i have seen in community that need to use Aggr function but no luck.

can any one suggest please.

Thanks

Rajesh

Re: Error in Calculated dimension

sunny_talwar — Thu, 31 Aug 2017 12:25:51 GMT

Over which dimension are you calculating the Count of nps_value?

May be this

Aggr(Num(((Count({<nps_value = {'Promoter'}>} nps_value)/Count(nps_value)) - (Count({<nps_value = {'Detractors'}>} nps_value)/Count(nps_value))), '#.#0%'), Dimension/s)

Re: Error in Calculated dimension

Rajesh — Thu, 31 Aug 2017 12:56:34 GMT

Thanks Sunny,

its working as expected,but have one thing to in it Pivot table

i would like to move NPS dim right to Promoter and hide the empty space nps_value.

Thanks

Rajesh

Re: Error in Calculated dimension

sunny_talwar — Thu, 31 Aug 2017 13:33:41 GMT

What is NPS dimension? Would you be able to share a sample?

Re: Error in Calculated dimension

Rajesh — Fri, 01 Sep 2017 05:04:54 GMT

Hi Sunny,

NPS dimension data is like nps_value(String value)

Re: Error in Calculated dimension

sunny_talwar — Fri, 01 Sep 2017 11:09:30 GMT

I am not 100% sure I understand your requirement.... do you mind elaborating a little bit?

Re: Error in Calculated dimension

Rajesh — Fri, 01 Sep 2017 12:05:02 GMT

Hi Sunny,

I have 3 dimensions 1.instance questions,2.nps_value(Detractors,Promoter etc), NPS(Calculated Cloumn)

Expression is Count(actual_value)

as u can see above screen shot i would like to dispaly NPS calculated to be moved to right side of Promoter and hide the nps_value column.

Please see below screen shot for u r reference. i hope u understand the requirement.