Qlik Community

New to Qlik Community

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

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

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
Highlighted

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