Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a line chart in my dashboard, it contains date like Jan-11,Feb-10.....
I am not able to sort the dates. I want the dates to be look like Dec - 12, Jan - 13, Feb - 13,.............
Thanks,
Hi Faisal
I am sending you a sample qvw file which solves your problem.
What I did, I first created a sample table with the same format as your month-year fields.
Then I resident loaded these values and converted the values to dates.
After that, I created a table box with the monthyear field and as you can see they are sorted by date, exactly as you want.
The most important thing here is the following:
date#(MonthYear, 'MMM - YY') AS MonthYear
(The 'MMM - YY' mus have exactly the same format as your original text monthyear field)
I hope this helps
Agis
Yes I have follwoed these steps, it changed the sorting but NOT in correct order.
Once you try with simple LoadOrder Option....in sot tab
Hi,
I suggested for particular field in the load script suppose there is a date field with data as you say i believe it is not in the date format it is text
Dec- 12
Jan - 13
Feb - 13
Mar - 13
Then you have to create that field into date format for (MMM - YY) also maintain the current format
Load
Date#(date,'MMM - YY') as MonthYear
From Location;
And you get month year as
Regards
Anand
There are other ways of doing this but I would need a bit more information about how these dates are loaded in your script.
Could you check the answers and close the discussion by selecting the Correct/Helpful answers Faisal?
This will help other people use this as a reference.
Thanks
Agis
I gave the same answer long time ago !