Discussion board where members can get started with Qlik Sense.
I have a table in excel that I need to bring into Sense. What I need is the table to show all dates between the admissiondate and the discharge date so from -
Go to Solution.
This creates millions of rows
its because i had null, thank you
How can i set the discharge date to today and it still work? I've got the below but i think something with the "While" needs doing
vent:LOADPatientID,EventNumber,AdmissionDate,AdmissionDate as CalendarKey,Date(AdmissionDate + IterNo() -1) as Date,if(DischargeDate='NULL',Today(),DischargeDate) as DischargeDate,SequenceIDFROM [..\..\.xlsx](ooxml, embedded labels, table is ImsEvent)while AdmissionDate + IterNo() < DischargeDate;