Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have some simple data that I wanted to allow date sorting on.
The rows are like
Sales order, amount, ship_date
So during the load I just used
Load *,
num(month(Shipment_Date)) as Month,
year(Shipment_Date) as Year;
This gets me the desired result of being able to click on say the 1 and select all of January.
Is there a better? different? more creative way of doing this? How would you do it?
Not sure what you are looking for or what defines a better way.
You can of course use also Month name
month(Shipment_Date) as Monthname
or combination of Year and month
year(Shipment_Date)&'/'&num(month(Shipment_Date)) as YearMonth
or what ever you want and suits your users need.
Stefan
P.S.
you may have a look to the variety of demo apps on the QlikView Web site or search for master calendar here (e.g. http://community.qlik.com/qlikviews/1001) to get some examples on how to use or presentate different date representations
Nachricht geändert durch swuehl
I guess I'm just to more further understand dates For example in the Master Calendar example
Month(TempDate) AS CalendarMonthName,
Creates the month name variables. By the very nature that it is a Date type of object and as long as another object that contains a date string is brought in as a date object is that what creates the tie between when you click on Jan and then all the January dates become selected
-Michael
Hi mellebeck,
You also able to create a field concatenated with Month and Year like
Load *,
num(month(Shipment_Date)) as Month,
year(Shipment_Date) as Year,
Month(Shipment_Date)&'-'&Year(Shipment_Date) as MonthYear
;
Hope this helps you.
Regards
Anand
MonthName(myDateColumn) is always my choice. Some of my older QVWs have concatenated month/year fields, but I've stopped using that option since it has several drawbacks (most notably being a string, so you can't put it in continuous axis graphs)