topic Re: setting date range in the app qvd layer in QlikView

setting date range in the app qvd layer

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have an urgent query regarding limiting the range wrt to the dates in the QVD layer.

right now i am using

LET vFromDate = Date(MonthStart(AddMonths(Today(),-122)),'YYYY-MM-DD') in the setup sheet

it limits the data from a certain date to the present date in the orders qvd and also in the calendars.

But i need to show the data from 2007 to 3years from the present date.

How do i update the expression?

Please help me.

Thanks & Regards,

Jaya

MK_QSL — Thu, 06 Apr 2017 06:28:11 GMT

You mean to say Data should start from 01/01/2017 to 06/04/2020? (i.e. Today 06/04/2017)

Thu, 06 Apr 2017 06:34:02 GMT

Hello Manish,

The data should start from Jan 2007 to april 2020(3 years ahead of present date).

Regards,

Jaya

ahaahaaha — Thu, 06 Apr 2017 06:39:24 GMT

Hi Jaya,

May be like this

LET vFromDateStart = Date('2007-01-01');

LET vFromDateFinish = Date(MonthStart(AddMonths(Today(),36)),'YYYY-MM-DD'); or

LET vFromDateFinish = Date(AddMonths(Today(),36),'YYYY-MM-DD');

And in code of script

[Field date] >= $(vFromDateStart ) And [Field date] <= $(vFromDateFinish )

Regards,

Andrey

saimahasan — Thu, 06 Apr 2017 06:39:35 GMT

You can use the following expression:

Let vStartDate = monthname('01/01/2007');

Let vEndDate = MonthName(AddYears(Today(),3)) ;

and then limit your data based on these 2 variables.

For eg: load *

from a.qvd

where Date_Monthname>=$(vStartDate) and Date_Monthname<=$(vEndDate);

Anil_Babu_Samineni — Thu, 06 Apr 2017 06:41:57 GMT

Then set analysis may be this. Make sure, The DateField and Today format should same

Sum({<DateField = {">=$(=YearStart(Today())) <= $(=AddYears(DateField, 3))"}>}Sales)