Date Selections

[sunilkumarqv]

     I have a dates like 1/31/2010,1/31/2011,1/31/2012,1/31/2013 (M/DD/YYY)

.I created chart above date as dimension ,So here if selected date 1/31/2012 in chart showing only 1/31/2012 I  pervious dates will be diappered .  I want to be presented previous dates as well I will appricate any one heelp me.

[sunilkumarqv]

Is possible show values in chart for dynamically created dates

[MK_QSL]

Can you elaborate your requirement in little depth?

[sunilkumarqv]

I have only 3months of  data with some value .

actually that 3months data is like 1/31/11,1/31/12,1/3/13 as Monthyear

in qlikview chart i  taken date as dimesion and some exps , So here in chart only comes that data. If we select 1/31/12

it want to  display  month end dates for example like this  1/31/11,2/31/11,3/31/11,4/31/11,5/31/11....12/31/11 dates  in

same way if we select  1/3/13 it should display 1/31/11 to 1/3/13

is there any way to do that  .

[MK_QSL]

Let vStart = NUM(Date('31/12/2012'));

Let vEnd = NUM(Date('31/12/2014'));

TempDate:

Load

  Date($(vStart) + RowNo() - 1) as Temp_Date

AutoGenerate $(vEnd) - $(vStart)+1;

Load

  *,

  AutoNumber(Date,'Date') as DateID,

  AutoNumber(YearMonth,'YearMonth') as YearMonthID;

Load

  Temp_Date as Date,

  Month(Temp_Date) as Month,

  Year(Temp_Date) as Year,

  Year(Temp_Date)&Month(Temp_Date) as YearMonth

Resident TempDate

Order By Temp_Date;

Drop Table TempDate;

========================================

Now You can use something like below...

Create a List Box for YearMonthID

SUM({<YearMonthID = {'$(=Max(YearMonthID)-12)'}>}Sales)

This will give you Last 12 Months Sale..

You can obviously change 12 with your required number.

[sunilkumarqv]

no its not working any other way do that

[MK_QSL]

It will be easy to work if you update you sample apps.

[sunilkumarqv]

see this i littel tired its realy helpful to me