topic Re: Incorrect values in pivot table in QlikView

Incorrect values in pivot table

udaya_kumar — Thu, 29 Sep 2016 12:26:54 GMT

Hi,

I have created a pivot table with two dimensions and an expression.

Two dimensions,

Segment and Day

Expression

Avg(value)

And given show value in % in number format of the table.

The value comes fine for each Segment (A, B, C, D,...) and Day wise (Mon, Tues, Wed, Thur, Fri, Sat, Sun)

for example.

Segment	Sun	Mon	Tue	Wed	Thu	Fri	Sat
A	15%	15%	15%	15%	10%	15%	15%
B	15%	15%	15%	15%	10%	15%	15%
C	-	-	-	-	-	-	-
D	-	-	-	-	-	-	-

If you consider the above table which looks like pivot table, Consider these values, and if you sum the % value by segment and day wise.

A - 7 days - 100%

B - 7 days - 100%

I get these types of right values in straight table, but in pivot table it gives values like

For segment A

Sun - 13%

Mon - 13%

Tue - 13%

Wed - 13%

Thu - 8%

Fri - 13%

Sat - 13%

Why is that pivot table shows incorrect values, but other charts like straight table, bar chart gives right value when I am using Avg expression?

Re: Incorrect values in pivot table

sunny_talwar — Thu, 29 Sep 2016 12:29:02 GMT

What are the expressions you are using?

Re: Incorrect values in pivot table

udaya_kumar — Thu, 29 Sep 2016 12:41:52 GMT

Just one expression, Avg(Value)

Re: Incorrect values in pivot table

sunny_talwar — Thu, 29 Sep 2016 12:44:47 GMT

What about in the straight table? Same expression?

Re: Incorrect values in pivot table

Anonymous — Thu, 29 Sep 2016 12:46:57 GMT

Hi Uday, could you share your data or one sample of your app?

Regards!

Re: Incorrect values in pivot table

udaya_kumar — Thu, 29 Sep 2016 12:48:15 GMT

Yes, in the straight table also the same expression.

It works fine there, but not in pivot table.

Data is from client, so cannot share it

Re: Incorrect values in pivot table

Anonymous — Thu, 29 Sep 2016 12:51:19 GMT

Try with this two expressions:

Avg(TOTAL <Segment, Day> Value) or Avg(Aggr(Avg(Value),Segment,Day))

Regards!!

Re: Incorrect values in pivot table

udaya_kumar — Thu, 29 Sep 2016 14:36:51 GMT

I had tried this expression before Avg(Aggr(Avg(Value),Segment,Day)), it did not work and i tried your given expression Avg(TOTAL <Segment, Day> Value) , this also did not work.

Re: Incorrect values in pivot table

Anonymous — Thu, 29 Sep 2016 14:38:35 GMT

It is complicated if we can't see some data example, you can do an Excel file with dummy data to help you.

Segment	Sun	Mon	Tue	Wed	Thu	Fri	Sat
A	15%	15%	15%	15%	10%	15%	15%
B	15%	15%	15%	15%	10%	15%	15%
C	-	-	-	-	-	-	-
D	-	-	-	-	-	-	-

Segment	Sun	Mon	Tue	Wed	Thu	Fri	Sat
A	15%	15%	15%	15%	10%	15%	15%
B	15%	15%	15%	15%	10%	15%	15%
C	-	-	-	-	-	-	-
D	-	-	-	-	-	-	-

Segment	Sun	Mon	Tue	Wed	Thu	Fri	Sat
A	15%	15%	15%	15%	10%	15%	15%
B	15%	15%	15%	15%	10%	15%	15%
C	-	-	-	-	-	-	-
D	-	-	-	-	-	-	-