Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
marishnagendran
Creator
Creator

Time Based Analysis

Hi All,

We have a number of customers working hours on daily basis.

Source Data be like:

marishnagendran_1-1677228198020.png

Output: 

A Customer working from 9.52 AM to 10.05 AM it shows in the chart

he not working from 10.06 AM to 12.05 PM  it not showed in the chart.

 

I want to show the working hours based on customers like below chart.

marishnagendran_0-1677228104386.png

It is possible in Qliksense?

Labels (6)
2 Replies
Nick_Asilo
Support
Support

@marishnagendran yes you can do math regarding date and time in Qlik Sense.

In this example, you seem to be counting each discrete minute worked so you have 14 entries for 9.52 AM to 10.05 AM. In that case, if you are concerned with the time worked within a particular day you can use the inday function to isolate all these entries and sum them up.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
marishnagendran
Creator
Creator
Author

@Nick_Asilo  Thanks for your response.

Could you please share any one example based on this scenario.

 

Thanks 

Marish