Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Min values in qlikview table

HI 

 

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

capriconuser_0-1598948776545.png

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

 

 

... 

 

1 Solution

Accepted Solutions
Kushal_Chawda

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

Annotation 2020-09-02 221024.pngAnnotation 2020-09-02 2210241.png

Here is the bar chart

Annotation 2020-09-02 2210242.png

View solution in original post

13 Replies
Taoufiq_Zarra

@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
Creator
Creator
Author

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?

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

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

capriconuser
Creator
Creator
Author

@Kushal_Chawda @Taoufiq_Zarra  this is what i want from data

Capture.PNG

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 :

Capture.PNG

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

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

Annotation 2020-09-01 151332.png

Your Output

Annotation 2020-09-01 151119.png

capriconuser
Creator
Creator
Author

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