Solved: Re: Min values in qlikview table - Qlik Community

capriconuser · ‎2020-09-01

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

...

Kushal_Chawda · ‎2020-09-02

try below

Data:
LOAD Year, 
     [Race Result], 
     Year&chr(10)&Pen as Key,
     Laps, 
     Pen, 
     Score
FROM
[Book1 (1).xlsx]
(ooxml, embedded labels, table is Sheet1);

Create bar chart with Dimension Key and below expression

sum(Pen)

Below are the bar graph settings

Here is the bar chart

View solution in original post

Taoufiq_Zarra · ‎2020-09-01

@capriconuser can you also share the expected output ?

in load Script or in UI ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

capriconuser · ‎2020-09-01

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

Taoufiq_Zarra · ‎2020-09-01

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

Kushal_Chawda · ‎2020-09-01

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

capriconuser · ‎2020-09-01

@Kushal_Chawda @Taoufiq_Zarra this is what i want from data

Taoufiq_Zarra · ‎2020-09-01

@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 :

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

Kushal_Chawda · ‎2020-09-01

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 · ‎2020-09-02

@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 · ‎2020-09-02

@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.