topic Re: Last 12 Months from QVD (in Load Script)? in QlikView

Last 12 Months from QVD (in Load Script)?

dmohanty — Fri, 20 Feb 2015 18:10:01 GMT

Hi All,

I have a Month/Year field in a Fact QVD (I have multiple Transnational Fields as well), where I have last 18 Months (Jan - 15, Dec - 14, Nov - 14, Oct - 14...... Aug - 13). Now while Loading into Script, I want to fetch only last 12 months.

What would be the logic to write in Load Script?

Re: Last 12 Months from QVD (in Load Script)?

Anonymous — Fri, 20 Feb 2015 18:20:09 GMT

You should be able to adapt this to your needs :

Where monthstart([YourMonthYear]) >= monthstart(addmonths(today(),-12))

Re: Last 12 Months from QVD (in Load Script)?

its_anandrjs — Fri, 20 Feb 2015 18:35:44 GMT

Hi,

Provide the sample file and did you have single fields as Month or year.

Regards,

Anand

Re: Last 12 Months from QVD (in Load Script)?

dmohanty — Fri, 20 Feb 2015 18:35:59 GMT

Hi Bill,

Thank you very much. Am checking it now.

But one query please-

Will this condition monthstart(addmonths(today(),-12)) ignore the Current Month? (I don't need Feb - 15, need Jan - 15 and backwards).

Re: Last 12 Months from QVD (in Load Script)?

dmohanty — Fri, 20 Feb 2015 18:38:35 GMT

Hi Anand,

The field is like this below. I need last 12 months from this: Jan-15 and backwards.

Re: Last 12 Months from QVD (in Load Script)?

its_anandrjs — Fri, 20 Feb 2015 18:47:20 GMT

Hi,

Then in the load script write this script

LOAD

MonthYear

FROM Source;

Where MonthYear >= (Addmonths(Today(),-13));

Regards

Anand

Re: Last 12 Months from QVD (in Load Script)?

Anonymous — Fri, 20 Feb 2015 19:13:18 GMT

Where monthstart([YourMonthYear]) >= monthstart(addmonths(today(),-13))

and monthstart([YourMonthYear]) <= monthend(addmonths(today(),-1))

Re: Last 12 Months from QVD (in Load Script)?

Anonymous — Fri, 20 Feb 2015 19:35:12 GMT

Hi,

try:

Load *
from DataQVD.qvd(qvd)
where Date >= AddMonths(Monthend(today()),-13) and Date < Monthstart(today())

Regards

Neetha