Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dimension Limitation Top30

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?

3 Replies

Re: Dimension Limitation Top30

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

Not applicable

Re: Dimension Limitation Top30

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

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.

Community Browser