how to ignore dimension limits in expression

[#1]

Hi,

my table is :

LOAD * INLINE [

    Car,Piece

    Ford, 10

    Toyota, 20

    Opel, 30

    Mercedes,  40

    Nissan,     50

    Seat, 60

    BMW, 70

    Audi, 80 ];

Dimension is Car and expression

sum (Piece) / sum (Total Piece)

I use dimension limits to show only  3 largest values but then in sum (Total Piece) Qlikview sum only 3 values and I want that it sum all 8 values. How to achieve this ?

Thanks

[anbu1984]

sum (Total Piece) - Should sum all the values. If its not working, can you provide sample output?

[amit_saini]

Hi,

Desired output???

Thanks,

AS

[#4]

[#5 · Accepted solution]

The reason that it did not work is because the document is created with Qlikview 10 and this version has different way to work with dimension limits.

Thanks anyway

[Gysbert_Wassenaar]

Try sum({<Car={'=rank(sum(Piece))<=3'}>}Piece)/sum({<Car={'=rank(sum(Piece))<=3'}>}total Piece)

[#7]

Gysbert,

problem is in version 10 created documnet. The same chart works fine in document created in version 11. Thanks for your help.

Greetings from Croatia