Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you post an example QVW with the same data. It will be easy to understand the issue.
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.
Please post some information about data & expressions
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
Thanks for all post..
Used unique entry no field for linking table and Problem solved..
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...