topic Re: Min values in qlikview table in QlikView

Min values in qlikview table

capriconuser — Wed, 25 Nov 2020 16:16:04 GMT

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

...

Re: Min values in qlikview table

Taoufiq_Zarra — Tue, 01 Sep 2020 09:09:40 GMT

@capriconuser can you also share the expected output ?

in load Script or in UI ?

Re: Min values in qlikview table

capriconuser — Tue, 01 Sep 2020 12:59:57 GMT

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

Re: Min values in qlikview table

Taoufiq_Zarra — Tue, 01 Sep 2020 13:10:38 GMT

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

Re: Min values in qlikview table

Kushal_Chawda — Tue, 01 Sep 2020 13:19:34 GMT

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

Re: Min values in qlikview table

capriconuser — Tue, 01 Sep 2020 13:49:43 GMT

@Kushal_Chawda @Taoufiq_Zarra this is what i want from data

Re: Min values in qlikview table

Taoufiq_Zarra — Tue, 01 Sep 2020 14:08:49 GMT

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

Re: Min values in qlikview table

Kushal_Chawda — Tue, 01 Sep 2020 14:15:57 GMT

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

Re: Min values in qlikview table

capriconuser — Wed, 02 Sep 2020 11:07:55 GMT

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

Re: Min values in qlikview table

Kushal_Chawda — Wed, 02 Sep 2020 11:19:02 GMT

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

Re: Min values in qlikview table

capriconuser — Wed, 02 Sep 2020 11:38:18 GMT

okay @Kushal_Chawda then how we can convert this data table into a pie or bar chart?

Re: Min values in qlikview table

Kushal_Chawda — Wed, 02 Sep 2020 13:14:34 GMT

@capriconuser you won't be able to convert to bar or pie. If convert it won't show anything. Somehow we can able to convert it but it won't show the exact values as in table as it will aggregate the data for individual year.

Re: Min values in qlikview table

capriconuser — Wed, 02 Sep 2020 14:57:17 GMT

@Kushal_Chawda u said i can add Pen column into dimension ... but what is this possible to get values through expression .. like if we do Min or something like that ? actually i want data in graph ..

Re: Min values in qlikview table

Kushal_Chawda — Wed, 02 Sep 2020 21:13:56 GMT

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