Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhapanka
New Contributor III

Sorting the X axis numericially isnt working

Hi in the graph below, i want the x axis to read - 2016-Q1, 2016-Q2 , 2016-Q3 and so on till 2018-Q3 so I sorted numerically with 'Fiscal year/ quarter' being the first to be sorted by however that is not happening and the years are all muddled up. How do I fix this?

5.PNG

Tags (1)
1 Solution

Accepted Solutions
sibin_jacob
Contributor III

Re: Sorting the X axis numericially isnt working

Select the Sort by Expression option, then use the below expression.

NUM(Replace(Year_Quarter,'-Q',''))

Then Select Ascending.

4 Replies
uroboros
Contributor

Re: Sorting the X axis numericially isnt working

Hi Malika,

It because the data set that you need to sort have a text format; try sort with one expresion or with a date field!

Regards!

nestigeek
New Contributor II

Re: Sorting the X axis numericially isnt working

Try Sort by Expression and use your Date field

sibin_jacob
Contributor III

Re: Sorting the X axis numericially isnt working

Select the Sort by Expression option, then use the below expression.

NUM(Replace(Year_Quarter,'-Q',''))

Then Select Ascending.

balabhaskarqlik
Honored Contributor

Re: Sorting the X axis numericially isnt working

May be try like this:

Date(Aggr(Max([Close Date]),FinancialYear/Quarter),'YYYY-MM')

Community Browser