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

Dates in Descending Order in loading script

Hi,

 

can some can help here i want all my dates in Descending Order always at project level

 

I wrote below Script

 

Temp2:

LOAD

PSA_Project_Internal_Id as [Project ID],
'' as [HOLD Closure date2],

(Date(Floor( [Created_Timestamp]),'MM/DD/YYYY')) as [HOLD Closure date]

FROM
[$(ITG_QVD_Path)\GSD_PSA_Project_History.qvd]
(qvd)
where (Field_Text= 'pse__Project_Status__c' AND (Old_Value_Text='On Hold')) ;

NoConcatenate

GSDHOLDClosuredate:

LOAD

[Project ID],
[HOLD Closure date],





Resident Temp2

Order by [HOLD Closure date] Desc;


drop table Temp2;

for above script i got below output

 

Desc.PNG

but i need dates in descending order like below

first 11/04/2020

10/12/2020

06/01/2020

whiling loading in script itself .

 

how can i write?

 

 

1 Reply
AnalyticsBoost
Contributor III
Contributor III

You are missing the statement:  group by [HOLD Closure date] 

First you need to do group by and second the order by

Some details here: https://community.qlik.com/t5/QlikView-App-Dev/Group-by-Order-by/td-p/932270