topic How to select Last 30 Records? in QlikView

How to select Last 30 Records?

shumailh — Sat, 24 Jul 2010 12:53:57 GMT

I tried Set Analysis \ use peek function but in the i couldn't found the proper solution to select last 30 records. Can anybody help me out?

Shumail

How to select Last 30 Records?

jonathandienst — Sat, 24 Jul 2010 14:37:26 GMT

Shumail

Can you do the determination of the last 30 in the load script?

Jonathan

How to select Last 30 Records?

shumailh — Sat, 24 Jul 2010 14:55:56 GMT

I can try... not sure either it will surve the purpose or not.

I know there is a clause first but last is not there.


First 10 Load * from abc.csv;

Regards,
Shumail Hussain

How to select Last 30 Records?

suniljain — Sat, 24 Jul 2010 15:17:56 GMT

Select first 30 record and order data in descending order.

How to select Last 30 Records?

shumailh — Mon, 26 Jul 2010 10:23:59 GMT

For the date field I am using the below expression but for others I think I can try Sunil's Suggestion.



=if(year(MnYr)=2010 or month(MnYr)=month(today()-30),(Sum(Count)))
<pre>
Regards,
Shumail Hussain</body>

How to select Last 30 Records?

shumailh — Tue, 27 Jul 2010 13:50:32 GMT

If this is the ways then, How would i modify the below code to first sort it by loadOrder and then select first 30

RBG_Fin_Grid:
CrossTable(RBG_Fin_MnYr, RBG_Fin_Amount)
LOAD
[RB] as Fin_Category, EOP, [NII],
[FEE_INC], [OI], [FEE_OI]
FROM [$(abc)\Jul-10\PD_Jul2010.xlsx]
(ooxml, embedded labels, header is 2 lines, table is [2008], filters(
Remove(Row, RowCnd(Interval, Pos(Top, 7), Pos(Top, 96), Select(1, 0))),
Transpose()
));

Like below????

RBG_Fin_Grid:
First 30 CrossTable(RBG_Fin_MnYr, RBG_Fin_Amount)
LOAD
[RB] as Fin_Category, EOP, [NII],
[FEE_INC], [OI], [FEE_OI]
FROM [$(abc)\Jul-10\PD_Jul2010.xlsx]
(ooxml, embedded labels, header is 2 lines, table is [2008], filters(
Remove(Row, RowCnd(Interval, Pos(Top, 7), Pos(Top, 96), Select(1, 0))),
Transpose()
)) Order by LoadOrder desc;

donot know how can i order my data by loadorder desc

Shumail

How to select Last 30 Records?

jonathandienst — Thu, 29 Jul 2010 09:18:37 GMT

Shumail

AFAIK it is not possible to do LoadOrder desc. I can suggest two alternatives

Load without a sort qualifier, and see if the load order corresponds to sorting by one or more of the fields. Then sort desc by that/those field(s).
Do the load in two passes - first load into a temp table with count field using RowNo() AS RowCount. Then load the last 30 rows from the temp table into the final table.

Jonathan

How to select Last 30 Records?

llauses243 — Fri, 30 Jul 2010 12:50:38 GMT

try ...

models:First 10 Load * from abc.csv;

How to select Last 30 Records?

llauses243 — Fri, 30 Jul 2010 13:19:28 GMT

sorry ... this is propose for Last 3 records...

Load

LOAD * INLINE [

Year,Indicator_Name,Values

2000,IndicA,50

2001,IndicA,60

2002,IndicA,70

2000,IndicB,50

2001,IndicB,60

2002,IndicB,70

2000,IndicC,50

2001,IndicC,60

2002,IndicC,70

];

qualify

last:

First

/Luis 3 Load * Resident T1 order by altnumber; *;*, Autonumber(Indicator_Name) as Indicator_Key, 100000000 - RowNo() as altnumber; //artificio

How to select Last 30 Records?

llauses243 — Fri, 30 Jul 2010 13:23:37 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1754.solution.txt:550:0]

sorry ... here clear in .txt attach ...