Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
nishatRini
New Contributor

How to restrict dimension limit at 80% ?

Hi, 

I want to restrict "Customer Name" which covers "80% of Total Sales". I have already tried all possible dimension limits.

 

Is there any way to restrict Dimension Limit at 80% in pie chart or straight table  ? ScreenShot.PNG

Please, help me. 

Thanks. 

Labels (1)
6 Replies

Re: How to restrict dimension limit at 80% ?

2019-01-07_21-35-15.png

Note that in some versions of QV12 "largest values" does not work.  It was fixed recently, can't recall the exact SR. 

-Rob

Highlighted
MVP
MVP

Re: How to restrict dimension limit at 80% ?

May be this:

Untitled.png

nishatRini
New Contributor

Re: How to restrict dimension limit at 80% ?

It is not working. Can you provide me any expression regarding this issue?

Re: How to restrict dimension limit at 80% ?

What version (version and SR) are you using?

-Rob

nishatRini
New Contributor

Re: How to restrict dimension limit at 80% ?

QlikView 12.10 SR4

Re: How to restrict dimension limit at 80% ?

Dimension limits accumulation largest values is a bug in 12.10. The issue us that it's actually using "smallest values" even though you select "largest values". It's fixed in Nov2018 release. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Community Browser