topic Re: Date in QlikView

Date

Mon, 13 Oct 2014 14:21:00 GMT

Hi all,

I have a field named 'date' in excel sheet which contains 'month-year' data. e.g. Nov-13

I am using this field as dimension axis for a particular graph and the problem is that it doesnt show in Nov-13 format , rather it shows as 1/11/13. How do i change it???

In the same field, for year i have values like 12,13,14 .

Now i need that dimension axis to be sorted as Jan-12, Feb-12....Dec-12,Jan-13,Feb-13......Dec-13,Jan-14,Feb-14...Dec-14

Please let me know the solution

Thanks in advance

Re: Date

its_anandrjs — Mon, 13 Oct 2014 14:32:43 GMT

Format your date field in the load script like

Load

MonthName(date) as Datefield, //First Way

date#( date,'MMM-YY') as date //Second Way

From Location;

Re: Date

Mon, 13 Oct 2014 14:40:21 GMT

Thanx Anand.

Can u also help with sorting order

Re: Date

its_anandrjs — Mon, 13 Oct 2014 18:04:36 GMT

Yes tell me what type of Sort Order.

Re: Date

Tue, 14 Oct 2014 05:46:47 GMT

its their in above post

Re: Date

ashfaq_haseeb — Tue, 14 Oct 2014 05:54:50 GMT

if you use

MonthName(YourDate) as MonthYear

Then you will have the desired sort you are looking at.

Regards

ASHFAQ