Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have requirement to map timestamp to 24 hours in a day like 0,1,2,3,4,5...23 hours in X-Axis.
i have START_, STOP date fields with Timestamps
so here i ma creating one Inline table like
Load * Inline [
Here i ma writing
Load START_,STOP Resident Interval_Table;
here i am getting result Every record on Interval_Table is mapping to Every record of Event_Table table .
Why it is happening like this what is the wrong here
Could you any one guide me here
Your Interval table is strange, there is overlap in times
Create an inline Interval table like this, think this is what you need:
Event_Table:Load * Inline [Time, Event00:59,001:59,102:59,223:59,23];
Interval_Table:Load * Inline [START,STOP,FromTo00:00:00,01:00:00,0-101:00:01,02:00:00,1-2];
Left join(Event_Table)IntervalMatch(Time)Load START,STOP Resident Interval_Table;
Left join(Event_Table)Load START,STOP,FromTo Resident Interval_Table;
Drop Table Interval_Table;