topic Best ways to create clickable month\year objects in QlikView

Best ways to create clickable month\year objects

mellerbeck — Fri, 22 Jul 2011 17:26:16 GMT

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?

Re: Best ways to create clickable month\year objects

swuehl — Fri, 22 Jul 2011 17:43:11 GMT

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

Re: Best ways to create clickable month\year objects

mellerbeck — Fri, 22 Jul 2011 18:12:12 GMT

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

Best ways to create clickable month\year objects

its_anandrjs — Tue, 16 Aug 2011 10:27:03 GMT

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

Best ways to create clickable month\year objects

Or — Tue, 16 Aug 2011 10:41:43 GMT

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)