Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm pretty new Qlik Sense user, and I'm making pivot table which shows those patients who have been in ready status between selected time range. I have columns OWNER_ID, START_TIME, END_TIME & STATUS. START_TIME & END_TIME are in hours, for example, 6. OWNER_ID column contains those patients who have "ready status"
For now my time selection is made with filter pane and you can select "0-2 o'clock", 3-5 o'clock", "6-8 o'clock" et cetera. When I select a time range, for example 6-8 o'clock, pivot table shows those patients whose start time is 6, 7 or 8, but it should show those who have been in ready status between 6 and 8 o'clock.
How to solve this? Thanks in advance.
More defined questions are welcome if needed.
Hi, depends on how you managed to get these ranges "0-2 o'clock", 3-5 o'clock"... you need to add additional AND condition for STATUS='ready'. So your expression could look like this:
if(START_TIME>=0 and END_TIME<=2 and STATUS='ready', '0-2 oclock', if(...
Ah, I should have mentioned in my queston that SQL code already selects rows where owner is in ready status. Sorry...