Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Experts,
I have a scenario with which i need a little help . After several operations on the base data i have created this table which is in the excel file.
From this table i need to fetch those application no's whose computerized tread mill test is issued after the ECG test.
For ECG test i have min_date_1 column and for computerized tread mill test i have min_date_2 column
How do i go about doing this ?
Regards,
Nadeem
Hi,
Try like this
TEMP:
LOAD APPLICATION_NO_1,
min_date_1,
min_date_2,
REQUIREMENT_DESC_1
FROM
TB12_20160916_204425.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Temp1:
LOAD
APPLICATION_NO_1,
Date1,
Date2
WHERE Flag = 1;
If(Max(min_date_1) < Min(min_date_2), 1, 0) AS Flag,
Date(Max(min_date_1)) AS Date1,
Date(Min(min_date_2)) AS Date2
RESIDENT TEMP
GROUP BY APPLICATION_NO_1;
View solution in original post
maybe like
Hi Stefan,
Thank you for your reply , i am sorry i did not mention that i wanted to do this in the scripting itself and create a table with all those application numbers.
Sorry for the late response but both the solutions are excellent and worked fine for me .
wish i could mark both of them correct .
Thanks for all your help. really appreciate.
