topic Re: Pivot table total in QlikView

Pivot table total

Anonymous — Mon, 08 Dec 2014 04:40:55 GMT

Here in the above pivot table .... i want the [final performance] Total and the expression for it is ...

=(if(Dimensionality()=1,

[Coperate SLP]*Performance

))

Re: Pivot table total

ecolomer — Mon, 08 Dec 2014 05:59:13 GMT

For the TOTAL Dimensionality is 0

if you question about Dimensionality()=1 never you have a result in the TOTAL (becuase this line is Dimensionality=0)

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 06:04:44 GMT

yaa but i want the sum of the above in total how can i make it happen .i tried many expressions .

Re: Pivot table total

SunilChauhan — Mon, 08 Dec 2014 06:18:35 GMT

goto chart properties-> supress zero values-> uncheck it

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 08:40:53 GMT

can u give me u r mailid??

Re: Pivot table total

SunilChauhan — Mon, 08 Dec 2014 08:58:43 GMT

you could send message to me using

create-> message. type name in to and write content and sent it. it will be visible to particular recipient

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 09:21:22 GMT

actually i tried ..sending u a private message but your name has not appeared there ...

Re: Pivot table total

SunilChauhan — Mon, 08 Dec 2014 09:42:24 GMT

add as a friend then .you would be able to send message

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 09:59:01 GMT

still u r name is not appearing over there...Sunil ... u send me u r mailid ?? i can tel u my query

Re: Pivot table total

simenkg — Mon, 08 Dec 2014 13:19:30 GMT

=(if(Dimensionality()<=1,

[Coperate SLP]*Performance

))

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 13:27:45 GMT

After

=(if(Dimensionality()<=1,

[Coperate SLP]*Performance

))

its like this ..Actually i want the sum of 109+0

As 109 to be appeared over there .

Re: Pivot table total

simenkg — Mon, 08 Dec 2014 13:33:45 GMT

if(Conditionality() = 0,

sum(Aggr(avg([Coperate SLP])*[Performance]),Group))

if(Dimensionality()=1,

[Coperate SLP]*Performance

))

)

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 13:38:53 GMT

i m not able to place this expression will you help by remote .....

Re: Pivot table total

simenkg — Mon, 08 Dec 2014 13:44:54 GMT

No.

You put that as the expression called Final Performance.

The reason it might not work is because you are referencing another column. Replace the [Coperate SLP] and [Performance] with the actual expressions used to calculate them.

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 13:49:28 GMT

Actually there i want to display sum of the values which got to be obtained in Final Performance .....

avtually if u see u can get it i think

Re: Pivot table total

simenkg — Mon, 08 Dec 2014 13:52:32 GMT

I understand, but if you want the sum of Final Performance shown on the Total line for Final Performance, then you have to use the whole expression as the expression for Final Performance.

If(Dimensionality() = 0,

Then we do this calculcation for the Total line,

if(Dimensionality() = 1,

Then we do this calculation or the sub total line

Then we do this calculation for every normal line

))

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 14:01:17 GMT

yes i have tried many like that but i m not getting result and fed up with it ...can u c through remote once please

Re: Pivot table total

simenkg — Mon, 08 Dec 2014 14:06:28 GMT

I am sorry, but I will not.

Create a new expression that is just:

Dimensionality()

Create another that is:
SecondaryDimensionality()

Then in your IF()-statement use the combination of the two that appears on your total line.

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 14:11:10 GMT

can i send u the expressions of [ corporate Slp ] and Perfromance .

ya write expression i tried many so.

Re: Pivot table total

Anonymous — Mon, 08 Dec 2014 14:25:40 GMT

can u please help me to write expression .