total showing wrong in pivot table at the time of expanding all column

[#1]

Hello,

Example:

Below screen shot value gets 3927--->>Correct value

Below screen shot value gets 3927--->>Wrong value

But actual value I want is 4947.

With Expanded mode

[Anonymous]

Can you post an example QVW with the same data. It will be easy to understand the issue.

[markmccoid]

It looks like your second dimensions has some duplication in it.  You see that when you expand 20 you get two rows, both with 1,020.  Usually in Qlikview is "smart" about this and realizes the duplication, but depending on your data model and your expression this may not happen.

I would start by investigating your data model. 

Post an example of you QVW and we can take a look.

[#4]

Please post some information about data & expressions

[#5]

Hi

yes, I guess your second dimension is in an other table which duplicates the line but the total is referenced to the first dimension.

So you can go around this by changing the way to sum it in tab expression

Check sum of the line instead of total of expression

best regards

chris

[#6]

Thanks for all post..

Used unique entry no field for linking table and Problem solved..

[MK_QSL]

difficult to understand your actual problem without knowing the real issue. Better to upload your data, file or .qvw...even we don't have dimension name and your expression...