Dimension Limitation Top30

Fri, 28 Jun 2013 15:27:42 GMT

Hi,

I have created a chart with 3 dimensions "Country", "Brand" and "Product segment" and the following expression:

=SUM({<

[Measures (Key)]={'Variable gross margin'},

[Version (Key)]={'$(=vToggle_Version_Key1)'},

[Type of data (Key)]={'1'},

[Business area (Key)]={'M'}

>}Values)-SUM({<

[Measures (Key)]={'Variable gross margin'},

[Version (Key)]={'$(=vToggle_Version_Key2)'},

[Type of data (Key)]={'1'},

[Business area (Key)]={'M'}

>}Values)

To this point no problem.

But now I would like to show only the top30 and the rest accumulated to "others".

With one dimension this is no problem but with three it does not work.

Furthermore I have a column showing the percentage of total using this calculation:

=column(1)/vCompensingEffectsSum*100

using the variable vCompensingEffectsSum

=SUM(

AGGR(

SUM({<

[Measures (Key)]={'Variable gross margin'},

[Version (Key)]={'$(=vToggle_Version_Key1)'},

[Type of data (Key)]={'1'},

[Business area (Key)]={'M'}

>}Values)-SUM({<

[Measures (Key)]={'Variable gross margin'},

[Version (Key)]={'$(=vToggle_Version_Key2)'},

[Type of data (Key)]={'1'},

[Business area (Key)]={'M'}

>}Values)

[Country group]

[Brand division]

[Product segment]

)

And I need a third column with the accumulated %-calculation.

Any suggestions?

Re: Dimension Limitation Top30

Nicole-Smith — Fri, 28 Jun 2013 18:44:43 GMT

Is there a reason you aren't using Dimension Limits set to 30 with the Others option checked?

Re: Dimension Limitation Top30

Tue, 02 Jul 2013 12:40:53 GMT

I have attached you a simplified example (top3).

The table example1 shows how it looks like now and example2 shows how it should look like (but I need it with 3 different dimensions instead of one concatenated dimension).

Re: Dimension Limitation Top30

Nicole-Smith — Tue, 02 Jul 2013 15:26:50 GMT

I was able to get it to work for top 3 and an others lines, but only by using two different charts--one for the top 3 and one for the others line. If you put them next to each other, it does look like the same chart. I think this is the best that I can do. Hopefully it helps.

topic Dimension Limitation Top30 in QlikView

Dimension Limitation Top30

Re: Dimension Limitation Top30

Re: Dimension Limitation Top30

Re: Dimension Limitation Top30