topic Re: RE:Bar Sort order in QlikView

RE:Bar Sort order

Chanty4u — Mon, 04 Apr 2016 08:42:05 GMT

Hi all,

I have some issue in bar chart where am unable to get sortout the yearmonth values in order.

Dimension:YearMonth.

REQ:in chart need to show values as

2015 oct

2015 nov

2015dec

2016jan

2016feb chk below my chart and sort tab;

2016mar

Re: RE:Bar Sort order

ecolomer — Mon, 04 Apr 2016 08:49:34 GMT

Change your selection to Numeric Value

Re: RE:Bar Sort order

Gysbert_Wassenaar — Mon, 04 Apr 2016 08:50:27 GMT

Create your Month_Year field as a date in the script: Date(MonthStart(MyDate),'YYYY-MMM') as Month_Year. Then sort it by Numeric Value in the chart.

Re: RE:Bar Sort order

jonathandienst — Mon, 04 Apr 2016 08:52:04 GMT

Create your YearMonth field as a proper datetime field and you can sort it numerically.

If you get the YearMonth as a text field from your source, then convert during the load:

LOAD ...

Date#(YearMonth , 'YYYY-MMM') as YearMonth,

...

Re: RE:Bar Sort order

Chanty4u — Mon, 04 Apr 2016 08:53:04 GMT

if i change to numeric...also its not givng

Re: RE:Bar Sort order

Kushal_Chawda — Mon, 04 Apr 2016 08:54:46 GMT

Your monthyear field is in string format. Make it in Number format like below

date(date#(MonthYear,'YYYY-MMM'),'YYYY-MMM') as MonthYear

Now go to Sort tab and sort it by Numerical values.

Re: RE:Bar Sort order

kaushiknsolanki — Mon, 04 Apr 2016 08:56:43 GMT

Hi,

It seems that the values (YearMonth) is a string. You must use the date format to get the values in numbers and then they will be sorted as per your requirement.

Use below function to get the Year Month.

Date(Date,'YYYY-MMM') as YearMonth

Regards,

Kaushik Solanki

Re: RE:Bar Sort order

er_mohit — Mon, 04 Apr 2016 08:56:57 GMT

Hi, Have you tried to checked Load Order Original and uncheck from all.

Hope it helps

Re: RE:Bar Sort order

Chanty4u — Mon, 04 Apr 2016 09:03:47 GMT

yes...its not working.

Re: RE:Bar Sort order

jlongoria — Mon, 04 Apr 2016 14:33:15 GMT

"The first thing you should be aware of is that there are two different functions: Date#() and Date(). The first is anInterpretation function and the second is a Formatting function". That is from this link...good stuff: The Date Function

This is what a possible solution for you would look like.

LOAD

Date#(MyTextDate, 'YYYY-MMM') as MyDate,

MyValue

;

LOAD * INLINE [

MyTextDate, MyValue

2015-Dec, 63

2015-Nov, 52

2015-Oct, 42

2015-Sep, 79

2016-Feb, 31

2016-Jan, 34

2016-Mar, 36

];