topic Re: Limit Dimensions in QlikView

Limit Dimensions

Tue, 21 Oct 2014 07:26:37 GMT

How to choose the first 5-10 dimention in a bar chart?

Say it has 20 dimentions, I want the 5th-10th ones. Is there any way to do it?

Thank you.

Re: Limit Dimensions

Anonymous — Tue, 21 Oct 2014 07:29:47 GMT

U mean the 20 dimension fields or 20 values for a single dimension? explain more clearly.

Re: Limit Dimensions

ashfaq_haseeb — Tue, 21 Oct 2014 07:35:35 GMT

Hi,

Based on what criteria you need to filter this?

Regards

ASHFAQ

Re: Limit Dimensions

jyothish8807 — Tue, 21 Oct 2014 07:42:32 GMT

Hi Anna,

Is there any criteria on which the dimension is sorted?

like assending order or descending sum(sales) or anything like this?

A screenshot will be helpful.

Regards

Re: Limit Dimensions

kuba_michalik — Tue, 21 Oct 2014 07:50:07 GMT

Easiest way would be to enable X-Axis scrolling when number of items exceed 6 (under Presentation tab), and let the users scroll themselves until only positions 5-10 are shown 😉

If you want to hard-limit the display to only those positions, it's more complicated.

Re: Limit Dimensions

Anonymous — Tue, 21 Oct 2014 08:01:33 GMT

U can use Calculated Dimension like this:

Here Product is the Dimension

and based on sum(price) i m ranking the product and taking only the dimension values falling between rank 5 to 10

=if(aggr(rank(sum(price)),Product) >= 5 and aggr(rank(sum(price)),Product) <= 10 ,Product)

Re: Limit Dimensions

Anonymous — Tue, 21 Oct 2014 08:03:59 GMT

One way of doing this is through a calculated dimension where you use a combination of AGGR and RANK.

E.g.

=IF(

AGGR(RANK(SUM(Amount),4),Dimension)>=5 AND AGGR(RANK(SUM(Amount),4),Dimension)<=10 ,

Dimension

)

See attached example.

Kind regards

Niklas

Re: Limit Dimensions

Tue, 21 Oct 2014 08:46:12 GMT

I mean the dimension fields for a single dimension.

Just want Jan-14 to Sep-14.

Re: Limit Dimensions

Anonymous — Tue, 21 Oct 2014 08:58:55 GMT

Ya u can achieve this in multiple ways:

1. When i see the chart,it seems the other dimension values are having null values- just go to Presentation tab enable the Suppress the null and Suppress the zero values options.

Re: Limit Dimensions

jyothish8807 — Tue, 21 Oct 2014 09:05:05 GMT

Hi Anna,

What is there in expression?

Iam asuming it is sum(Turnover Postponed)

Then try like this in expression:

sum({Date={'>= Jan-14 <= Sep-14'}>}[Turnover Postponed])

sum({Date={'>= Jan-14 <= Sep-14'}>}[Customer Serivce rate])

Regards

Re: Re: Limit Dimensions

Anonymous — Tue, 21 Oct 2014 09:13:23 GMT

You have some ideas in my updated example and picture below.

Still based on AGGR/RANK.

If I understand you correctly you want to show all data points, but only show the legend for a few of them.

Karthigayan's suggestion would work for null-values, but if you still want to show the red line it will not work.

Kind regards

Niklas