What techniques are there to match a number with an interval? How does the IntervalMatch prefix work? Should I join the interval match table with the event table? How do I generate an interval f...
IntervalMatch and Slowly Changing Dimensions.pdf (374 KB)
...0', '24/11/2017 15:59', 4 3, sara, '24/11/2017 16:00', '24/11/2017 23:59', 5 I need to know how much money is made during the shifts of every floor manager. I've tried to use IntervalMatch but I h...
Hi, I have two tables, containing hourly wages and the hours worked. The table containing the hourly wages is built as following: Every employee has a record (or multiple) with...
Hi, I'm working on data which extracted from Google Calendar where the users update their PTOs, Work From Home, etc. I'm able to extract the info but I need it in a different format. Extracted ...
Hi! I have two database tables: one that holds visits to websites and another which contains a schedule of classes. I need to join the two tables so I can track the websites visi...
Hi everyone, I need your help with this issue. I have a main EVENT table. For each event I have an EventID (unique key) and several attributes including EventDate (datetime) and EmpID (foreign key)....
Hi, I'm quite new to Qlik Sense and I'm trying to do cumulative graph visualizing the status of our work orders of our project. My data looks like this: Work order number wor...
.png "Former Employee"){kind=icon}
