Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to move a report from Excel into QlikSense. But i'm having trouble when it comes to replicating certain graphs on the report.
One chart in particular from Excel breaks down performance data throughout the day, which is provided in 5 minute intervals, and displays it in 40 minute intervals.
However when trying to shows this in QlikSense it either displays every minute timestamp, or when i try to change it it goes the other way and shows just the data per day.
Can anybody help with any ideas how to set this interval in the line chart itself or any load ideas i can use?
(i did try rounding to the nearest half hour but it just changed my year and dates to 1989.
For reference my timestamp data is DD/MM/YYYY HH:MM:SS
Hi
you can flag the timestamp when minutes are 00 , 20 or 40 :
something like :
if(match(minute(MyData),'00','20','40'),'40 mm interval') as MyData_40,
then use dim MyData_40 as dim in your graph
Or in you graph use a calculated dimension
aggr( if(match(minute(MyData),'00','20','40'),MyData),MyData)