Dimension Limits - Top 80%

[#1]

Can someone tell me why when I use the Dimension Limit 80% of Relative Total Using Largest Value, the lowest value is included?

Below are all my values sorted Descending (this is the first expression and I only have one Dimension)

and this is what I get when I set the dimension limit to accumulate to 80% of Relative Total Using Largest Value

shouldn't the record with a total of $5000 come next?

[MarcoWedel]

Hi,

seems this question has already been discussed some years ago:

QV 11 Dimension Limits with negative values

https://community.qlik.com/message/173938#173938

so in essence it:

"Works as designed."

hope this helps

regards

Marco

[Gysbert_Wassenaar]

Well, I didn't ask for that specific qlikview document. Just 'a' qlikview document that demonstrates the problem. If you're worried about confidential information perhaps this document helps: Preparing examples for Upload - Reduction and Data Scrambling

[Gysbert_Wassenaar]

I'm pretty sure that the negative invoice amounts are leading to unexpected behaviour. See attached example. With negative amounts the relative total can go over 100% and you can get two 80% boundaries. I'm not sure there is a correct behaviour in this case. It's like showing negative values in a pie chart. It just doesn't make sense. Negative sized areas are not possible (outside exotic physics).

[rajeshvaswani77]

Select Global Grouping Mode.

regards,

Rajesh Vaswani

[antoniotiman]

Hi Jessica,

see Attachment.

Regards,

Antonio