Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
sum (Total Piece) - Should sum all the values. If its not working, can you provide sample output?
Hi,
Desired output???
Thanks,
AS
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
Try sum({<Car={'=rank(sum(Piece))<=3'}>}Piece)/sum({<Car={'=rank(sum(Piece))<=3'}>}total Piece)
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