Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shafiqur_Khan
Contributor II
Contributor II

How to sort Quarter (Q1, Q2, Q3) in order in X axis of Bar chart?

Hello,

I am absolutely new in Qlik. So, I was trying to visualize some data through bar chart, where the X axis contains the  data of time elapsed in Quarter. I used the following script to do so. But in the bar chart the quarters are not in order like Q1, Q2, Q3.  What to change? What am i missing?

Thanks for your help!

Load
  [Change ID],
 Date(floor([Created])) AS Created_Date,
  Month(Date(floor([Created]))) as Created_Month,
 Dual('Q'&Ceil(Month(Date(floor([Created])))/3),Ceil(Month(Date(floor([Created])))/3)) as Created_Quarter,
  [In work date] - Date(floor([Created])) AS In_work_timelapse
 

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

You are probably sorting by measure. 

Go to sorting in your chart objects properties and reorder your sorting to sort by Quarter before your expression value.

image.png

 

image.png 

View solution in original post

4 Replies
Vegar
MVP
MVP

You are probably sorting by measure. 

Go to sorting in your chart objects properties and reorder your sorting to sort by Quarter before your expression value.

image.png

 

image.png 

lironbaram
Partner - Master III
Partner - Master III

hi 

it seems you need to go to the chart properties , and in sorting make sure your dimension is the first field to appear 

Shafiqur_Khan
Contributor II
Contributor II
Author

Thanks!

Shafiqur_Khan
Contributor II
Contributor II
Author

Thanks! worked perfectly!