topic Re: Dates Logic Help in QlikView

Dates Logic Help

abhaysingh — Wed, 03 Feb 2016 16:05:44 GMT

Hi Guys,

I have dates like in one table

01-01-2015,

01-02-2015,

01-03-2015

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2015

01-11-2015

01-12-2015

i want that first3 month Dates will change to

01-01-2016,

01-02-2016,

01-03-2016

but when i click Jan it shud give me 01-01-2016 rather than 01-01-2015

how i can achieve that?

pls suggest

Re: Dates Logic Help

swuehl — Wed, 03 Feb 2016 16:09:39 GMT

I don't understand what you are trying to do.

Do you want to create a financial calendar that ranges from April 2015 to Mar 2016 for FY 2015?

Re: Dates Logic Help

datagrrl — Wed, 03 Feb 2016 16:14:27 GMT

Maybe an example QVW would help. Are you talking about a month filter/list box?

Re: Dates Logic Help

abhaysingh — Thu, 04 Feb 2016 05:17:21 GMT

Hi Guys,

I have Year and Month as per Fiscal Year in a table, like year 2015 and their Month

Apr,May,Jun, Jul ,Aug, Sep,Oct,Nov,Dec,Jan,Feb,Mar

So i want to create the date like below

01-01-2015,

01-02-2015,

01-03-2015

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2016

01-11-2016

01-12-2016

kindly suggest

Re: Dates Logic Help

avinashelite — Thu, 04 Feb 2016 05:40:53 GMT

Hi Abhay,

Could you please explain your requirement in detail ?

According to me you could create a master calendar according to your need and link with your data .

Creating A Master Calendar