Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Grouping

Hi,

i am trying to get  "Grouprowno"  by grouping at project level.

so if one project ID  has 3 timestamps  then my Grouprowno i am getting as 1, 2 and 3 .  as per below.

but from below tables Group row field should give me 1 where timestamp is higher and then 2 for second higher time stamp and so on. so how can i write ?New.PNG

this is what my script i wrote to get above table output  and now i want to modify accordingly higher timestamp should get 1 and second higher timestamp should get 2 then so on for GroupRow field. how can i modify my below scripting?

 

Temp:

LOAD

Rowno,
[Project ID],
[HOLD Closure date],
[PSA Project pse Project ID]
FROM
[$(QVD_Path_CD)\D1.qvd](qvd);

NoConcatenate

GSDHOLDClosuredate1:


LOAD
Rowno,
[Project ID],
[HOLD Closure date],
[PSA Project pse Project ID],
IF([PSA Project pse Project ID]<> Previous([PSA Project pse Project ID]), 1, Peek('GroupRow')+1) AS GroupRow

Resident Temp
Order By [PSA Project pse Project ID], [HOLD Closure date]

;

 

drop table Temp;


STORE GSDHOLDClosuredate1 into [$(QVD_Path_CD)\D1Base.qvd];

exit script;

0 Replies