Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a requirement where i need to put a chart like Count and Sum by only hour irrespective of date, example below
so when i take count, the output should be below
so please help me achieving this!!
The easiest way would be to create a new field in the load script called "hour".
You can easily use the Hour() function to achieve this.
eg, if DateTime is your existing field, something like this would then allow a count to be preformed on the new "hour" field.
Hour(DateTime) as hour
You can then easily create a bar chart for example of hour by count(hour).
I've attached a very simple example with your data.
Have a look at the attached file.
Hope it helps!
Hope it helps !
mid(field_date,12,2) as Hour,
hour(field_date) as Hour_Count
use a calculated dimension, if your field is datetime
Your requirement for count and sum of hour,it's unclear.
if you want to count of how many hours an work is done.
you need to take a max hour of each day and sum it.
then you might achieve the requirement you need.
Hi Shrihari J, could you please confirm if this is a Qlik Sense or QlikView problem they are having?
This has been posted in the Qlik Sense forum, however a couple of these suggestions are relating to QlikView.
Thank you all for the replies. used 'Hour(datetime) as Hour' while loading, its working fine.