Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan2391
Creator II
Creator II

Show hourly data in bar chart

Hi Team,

I have a date field 'orderdate' which is having data in the format 'DD/MM/YYYY hh:mm:ss'.

I want to design a bar chart with Hour as dimension and sum(sales) as measure. 

But user wants to see the hour representation in this format 'MMMDD-hh' (Ex: Nov14-06).

For this, I have written

Month(orderdate)&Day(orderdate)&'-'&Hour(orderdate) as Hour.

Here the issue is with SORTING. I am not able to sort it correctly in chart.

Could you please suggest a way to resolve this sorting issue ?

and also is there any other way to get the hour in the required format with NO sorting issue ?

Thanks in advance

Regards

BMK

1 Solution

Accepted Solutions
sunny_talwar

May be create a new field for Sorting

(Month(orderdate)*10000) + (Day(orderdate)*100) + (Hour(orderdate)) as HourSort

View solution in original post

4 Replies
sunny_talwar

May be create a new field for Sorting

(Month(orderdate)*10000) + (Day(orderdate)*100) + (Hour(orderdate)) as HourSort

View solution in original post

mohan2391
Creator II
Creator II

WoWWWWW.. 

It worked..

Thank You!! 🙂 🙂

jonathandienst

Use 

TimeStamp(orderdate, 'MMMdd-hh')

or better, to ensure only one value per MMMdd-hh value:

TimeStamp(Round(orderdate, 1/24), 'MMMdd-hh')   //nearest hour
or
TimeStamp(Floor(orderdate, 1/24), 'MMMdd-hh')     // last complete hour

Now you can just sort numerically.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mahaveerbiraj
Creator II
Creator II

Hi mohan,

try with  sort by expression  and in expression add num(orderdate)    may be it will solve your sorting problem