Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

6 Replies
aadilmadarveet
Valued Contributor

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

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

markmccoid
Contributor II

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

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.

Not applicable

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

Please post some information about data & expressions

Not applicable

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

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

Not applicable

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

Thanks for all post..

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

MVP
MVP

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

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...

Community Browser