topic Re: Date generate in table in QlikView

Date generate in table

Fri, 28 Dec 2012 16:31:32 GMT

I have two dates StartDate and EndDate, when I select those dates I have to generate all the dates between them.......tnx

Re: Date generate in table

chematos — Fri, 28 Dec 2012 16:52:56 GMT

let vStartYear = Year(StartDate);

Dates:

load date( makedate($(vStartYear))+rowno()-1) as Date

AutoGenerate( today()-makedate($(vStartYear))) ;

Hope this helps

Re: Date generate in table

Fri, 28 Dec 2012 17:33:26 GMT

Thanks for the reply,

I want in the front end, UI side.......I have two date fields.......and if I select those dates I should able to populate all the dates between those selections......

Re: Date generate in table

chematos — Fri, 28 Dec 2012 18:24:08 GMT

you will need a date field with all dates, and you can use a calculated dimension using that date like this:

if(Date <=StartDate and Date >= EndDate, Date)

Re: Date generate in table

Fri, 28 Dec 2012 18:39:52 GMT

please find the attached sample pics...I have two date fields with selections.....and the other one is table with all the dates......

Re: Date generate in table

chematos — Fri, 28 Dec 2012 18:51:36 GMT

Do you have a calendar? You need a calendar or a Date field linked with your date field of your fact table, the date field you are going to use in your chart.

You must have a table with this fields and more: Date, Sales or whatever you're measuring in your chart.

StartDate and EndDate could be variables, better than fields.

And you should have a Calendar that contains all your possible dates with a few fileds or more: Date, Year, Month, Week, etc.

Do you understand??