Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart?

[#1]

Qlikview - How to create a line chart with selected item (Dimension: Product, selected by filters) and the other top 5 (Dimension: Product), all in the same chart?

[Anonymous]

you could use a synthetic dimension

for example valuelist('Selection','Top5')

and then an expression something like that

if(valuelist('Selection','Top5')='Selection',

     //Selection

     sum(YourFIELD),

     //top 5 ingnored selection

     sum({1<  YourFIELD={"=Rank(sum(YourField),4)<=5"}  > } YourFIELD)

)

I think I was wrong, you can just use 2 separate expression like that

     sum(YourFIELD)

     sum({1<  YourFIELD={"=Rank(sum(YourField),4)<=5"}  > } YourFIELD)

[#3]

Hello Robin, Thanks! Would be possible Top 5 - item by item together with the item selected? (6 lines)

[Anonymous]

if(

     rank(total sum(YourField),4)<=5,

           sum(YourField)

)

----------------

total is optional