Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I am in a big fix and have been spending days to figure out few things in qliksense.
i have the folowing table :
and the result should be each mode type and id
id date_time mode mode_start mode _endtime
can you please help here urgently
best
ïndrani
can u try like below:
tab:
load * inline [
date,mode
01/12/2021,A
01/12/2021,B
04/12/2021,A
02/12/2021,B
05/12/2021,A
06/12/2021,B
];
t2:
load mode,date(min(date)),date(max(date)) resident tab group by mode;
Hi sorry what happens if the datefields are different for each field. see column 1