topic Re: Pivot table Total issue with expression in QlikView

Pivot table Total issue with expression

Anonymous — Mon, 08 Dec 2014 15:59:12 GMT

Here in this pivot table i m having the issue with the Performance Total it is varying .

It should be Sum([Coperate SLP])*[Performance])

Means (103*106)+(0*111)=109.18 but its displaying as 111 that is the problem over here.

Please Help me guys since a week i m striving to get it done but its not getting perfect.

Re: Pivot table Total issue with expression

prieper — Mon, 08 Dec 2014 16:12:02 GMT

Suggest to include the fields, which you wish to factorize one-by-one into the chart and verify, that the values are really as you expect.

HTH Peter

Re: Pivot table Total issue with expression

Anonymous — Mon, 08 Dec 2014 16:17:03 GMT

hi peter ,

i m trying since a week and its annoying for me can u remote me and

help .if possible for u means.

On Mon, Dec 8, 2014 at 8:12 PM, Peter Rieper <qcwebmaster@qlikview.com>

Re: Pivot table Total issue with expression

Anonymous — Mon, 08 Dec 2014 16:17:20 GMT

hi peter ,

i m trying since a week and its annoying for me can u remote me and help .if possible for u means.

Re: Pivot table Total issue with expression

prieper — Mon, 08 Dec 2014 16:23:29 GMT

please attach an sample-file with your problem

Peter

Re: Pivot table Total issue with expression

Anonymous — Mon, 08 Dec 2014 16:26:03 GMT

actually its a huge app and expressions can u take remote its easy .

On Mon, Dec 8, 2014 at 8:24 PM, Peter Rieper <qcwebmaster@qlikview.com>

Re: Pivot table Total issue with expression

Anonymous — Mon, 08 Dec 2014 16:30:12 GMT

how does the expression for column "Performance" and "Corporate SLP" looks like?

Re: Pivot table Total issue with expression

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

i will send u all the expressions as text please check ....

On Mon, Dec 8, 2014 at 8:31 PM, Rudolf Linder <qcwebmaster@qlikview.com>

Re: Pivot table Total issue with expression

Anonymous — Tue, 09 Dec 2014 03:38:25 GMT

hi rudolf ,

Can u share me u r mail id please.

Re: Pivot table Total issue with expression

ashwanin — Tue, 09 Dec 2014 04:36:56 GMT

Hi Bunny,

To check it you must have to add the sample qvw.

Re: Pivot table Total issue with expression

Anonymous — Tue, 09 Dec 2014 04:40:07 GMT

actually its a huge application thats why i have not posted and can u give me u r maild id.

Re: Pivot table Total issue with expression

ashwanin — Tue, 09 Dec 2014 05:06:00 GMT

Can you create a sample data and post it here .

Re: Pivot table Total issue with expression

Anonymous — Tue, 09 Dec 2014 05:12:07 GMT

hey i have posted my screen shot and sample means tough to evaluate and can u ping me by mail i can show u my dashboard

Re: Pivot table Total issue with expression

prieper — Wed, 10 Dec 2014 09:34:36 GMT

Think it is not fitting into the idea of a forum to handle part of discussions in private mails.

It can also be expected to explain your problem in short and to post the formulas used.

Just my two cents

Peter

Re: Pivot table Total issue with expression

Anonymous — Wed, 10 Dec 2014 09:51:49 GMT

actually i tried to make it small but due to complexity its not possible for me . bunnyqlik@gmail.com