Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to ignore dimension limits in expression

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
anbu1984
Master III
Master III

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

amit_saini
Master III
Master III

Hi,

Desired output???

Thanks,

AS

Not applicable
Author

Not applicable
Author

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

View solution in original post

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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