topic Re: Calendar in QlikView

Calendar

smilingjohn — Tue, 01 Dec 2015 09:25:41 GMT

Hi All

I have a excel file which has the date from 01-01-201 to 17-11-17

I have createed the master calendar , But its not working from the actual date .

Can someone suggest me wher iam gpping wrong ? Please find the attachment of the excel file and qvw

MK_QSL — Tue, 01 Dec 2015 09:40:35 GMT

What is the exact problem you are facing?

smilingjohn — Tue, 01 Dec 2015 09:43:41 GMT

hi Manish

If u look at the table in my dashbaord attached above , the date conversion is not happening for the given date .

In my excel i dont have date starting from 2014 it in the master calendar it is starting from 2014.

And also ther is no conversion happening for my actaul date , which is from 2016

engishfaque — Tue, 01 Dec 2015 09:53:32 GMT

Dear John,

2014 is coming from listed below variable, please check

LET vStartDate = Num(YearStart(Today(), -1));

Kind regards,

Ishfaque Ahmed

tamilarasu — Tue, 01 Dec 2015 09:54:44 GMT

Check the attachment

PrashantSangle — Tue, 01 Dec 2015 10:01:25 GMT

Hi,

update your below variable and try

let vStartDate=Num(Peek('Date',0,'date'));

let vEndDate=Num(Peek('Date',-1,'date'));

Regards

engishfaque — Tue, 01 Dec 2015 10:12:15 GMT

Dear John,

Kindly find attached document, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed