Min values in qlikview table

[capriconuser]

HI 

i have a data like this . I will attach data also 

now from that data  i want to show that in the past 10 races, the teams who have low Pen will win the races 

... 

[Taoufiq_Zarra]

@capriconuser  can you also share the expected output ?

in load Script or in UI ?

[capriconuser]

JUST WANT to show 10 min penalities values in table against year @Taoufiq_Zarra 

[Taoufiq_Zarra]

i.e. for each year, e.g. 2010, the 10 lowest values or the lowest value of 2010?

[Kushal_Chawda]

@capriconuser There are some repeated Pen in 10 min Pen. Do you want to show all the records ?

[capriconuser]

@Kushal_Chawda @Taoufiq_Zarra  this is what i want from data

[Taoufiq_Zarra]

@capriconuser  Maye be like this :

Data:

LOAD Year, 
     [Race Result], 
     Laps, 
     Pen, 
     Score
FROM
[.\Book1(1).xlsx]
(ooxml, embedded labels, table is Sheet1);

Tmp:
noconcatenate

First 10 load * resident Data order by Pen DESC;

drop table Data;

output :

[Kushal_Chawda]

Create  straight table with Dimension Year and Pen

Sort the Pen dimension (Promote it to Top). Go to chart properties-> Sort -> Numeric-> Descending

Go to chart properties->Presentation and check the below option

Your Output

[capriconuser]

@Kushal_Chawda i tried but this works only for table whereas when i try to convert this table into Pie or Bart chart and put  Min(Pen) in expression then this shows incorrect data.

[Kushal_Chawda]

@capriconuser  well, bar chart and pie chart are not suitable to represent this data as you want to represent unique instance of values whereas graphs always represents aggregated data.