topic Re: Date Variable in QlikView

Date Variable

Thu, 20 Sep 2012 14:50:59 GMT

Hi I am new to QV.

I am trying to create a variable where user can select from and to dates.

Any suggestions on how i go about doing so?

I am loading data in a crossable format from a flat file with date dimension are going across in columns.

Product Period 1 FY12 Period 1 FY1 Period 1 FY13

1 $100

2 $200

3 $300

4 ETC

thank you

Re: Date Variable

Miguel_Angel_Baeyens — Thu, 20 Sep 2012 15:20:49 GMT

Hi,

Feel free to download this app and use the code within. You have a basic master calendar and a few charts that demonstrate how to use variables with dates, let the user select periods (ranges of dates) and how the charts should be built to respond to these interactions.

Hope that helps.

Miguel

Re: Date Variable

Thu, 20 Sep 2012 17:37:31 GMT

Hi Miguel,

Your link was extreemly helpfull.

Another question about dates. In your query, you are tranlating date to 2007. I am working with fiscal periods, sample below. HWould you be able to help me tranlate fiscal periods, going back to 2009?

Sales:

LOAD

Chr(64 + Ceil(Rand() * 5)) AS ID, // Company ID

Ceil(Rand() * 7) * 1000 AS SalesAmount, // Amount

Date(Ceil(Rand() * 1460) + Date('01/01/2007')) AS CalendarDate // Date starting Jan 1, 2007

AUTOGENERATE 3000;

[Period 12 FY2009] ,

[Period 1 FY2010],

[Period 2 FY2010],

[Period 3 FY2010],

[Period 4 FY2010],

[Period 5 FY2010],

[Period 6 FY2010],

[Period 7 FY2010],

[Period 8 FY2010],

[Period 9 FY2010],

[Period 10 FY2010],

[Period 11 FY2010],

[Period 12 FY2010],

[Period 1 FY2011],

[Period 2 FY2011],

[Period 3 FY2011],

Thank you