This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to load only rows which fall into the top 4 values in a field
So for the above table, I only need to load RiskID 1234, 1236, 1237, 1239, 1240 as the scores fall into the top 4 for the field
There are some others ways yo ucan do this, but I'll show you one.
Temp:LOAD * inline [Customer|Product|OrderNumber|UnitSales|CustomerIDAstrida|AA|1|10|1Betacab|AA|5|4|2Canutility|CC|13|19|3Divadip|AA|9|16|4] (delimiter is '|');
First 2Final:LOAD * Resident Temp Order By UnitSales desc;
Drop Table Temp;
In your case, you should change First 2 to First 4.
I have tried something similar to this
first 2 will only load the first two rows
If my top 3 rows are
i need all three loaded as all three rows are in the top two values
first 2 will miss row 3 in this case
You can try with:
//First 2Final:LOAD * ,If(RowNo()=1,1,(1+peek("Rank"))) as RankResident TempOrder By UnitSales desc;
Try like below
Temp:LOAD * INLINE [RiskID, Score1234, 501235, 241236, 451237, 451238, 271239, 321240, 35];
Temp1:Load *, If(Rowno() = 1, 1, If(Peek('Score') <> Score, Peek('Rank')+1, Peek('Rank'))) as Rank Resident Temp Order by Score desc;
NoConcatenateFinal:Load RiskID, Score Resident Temp1 where Rank <= 4;
DROP Table Temp, Temp1;