topic Re: Smallest Dimension limits in QlikView

Smallest Dimension limits

jchoucq — Tue, 20 Nov 2012 15:53:59 GMT

HI everybody,

for example, i want to show the 5 smallest sales in a bar chart and when i use Smallest Dimensions Limits, the bar chart gives no data to display because many salesman have no sales !

Is it possible, in a bar char to have the 5 smallest values, which are different from zero.

Regards,

Johann

Re: Smallest Dimension limits

MayilVahanan — Tue, 20 Nov 2012 16:53:16 GMT

You can use rank() function for that,

for ex:

in expression

if(rank(sum(Sales)) < 5, sum(Sales))

greater than zero,

u can use like this

=if(rank(sum({<Sales = {'>0'}>}Sales)) <=5, sum(Sales))

hope it helps

Re: Smallest Dimension limits

christian77 — Tue, 20 Nov 2012 17:04:37 GMT

Watch! rank fuction = 1 is first, no last. 2 is the second, and so on. is there an inverse rank?

example kank(Vettel) = 1, rank(Alonso)=2, ......, rank(last), we don't know. How many are they?

If is a simple table, use dimension limits.

In the presentation tab check suppress cero values.

Re: Smallest Dimension limits

jchoucq — Tue, 20 Nov 2012 17:27:40 GMT

it seems that suprress 0 value with smallest in the dimensions limits doesn't work.

I will try to send an example

Re: Smallest Dimension limits

MayilVahanan — Tue, 20 Nov 2012 17:38:52 GMT

For inverse,

rank(-sum(Sales))

hope it helps

Re: Smallest Dimension limits

jchoucq — Tue, 20 Nov 2012 18:02:10 GMT

thank you for your answers.

as a conclusion, the smallest option in the dimension limits is diffocult to use without writing a specific expression. See qvw in attachement

Re: Smallest Dimension limits

MayilVahanan — Tue, 20 Nov 2012 18:08:43 GMT

PFA

Re: Smallest Dimension limits

jchoucq — Tue, 20 Nov 2012 18:12:28 GMT

thank you, i know this method in a straight table, but we can't do the same in the bar chart below !

Re: Smallest Dimension limits

MayilVahanan — Tue, 20 Nov 2012 18:27:29 GMT

PFA

Hope it helps

Re: Smallest Dimension limits

jchoucq — Tue, 20 Nov 2012 18:51:00 GMT

Thank you very much Mayil. It works indeed.

But i noticed you don't use Dimensions Limits

Re: Smallest Dimension limits

Gysbert_Wassenaar — Tue, 20 Nov 2012 20:38:56 GMT

It works with as calculated dimension if(aggr(sum(MT_FACT),CODE_CLT)>0, CODE_CLT) and Suppress When Value Is Null checked. See attached example.

Re: Smallest Dimension limits

jchoucq — Wed, 21 Nov 2012 08:48:18 GMT

Thanks a lot Gysbert.

For sure, how works Smallest Dimension limits is strange