can some can help here i want all my dates in Descending Order always at project level
I wrote below Script
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')) ;
LOAD [Project ID], [HOLD Closure date],Resident Temp2Order by [HOLD Closure date] Desc;
drop table Temp2;
for above script i got below output
but i need dates in descending order like below
whiling loading in script itself .
how can i write?
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