Last month qvw

[#1]

Hi,

So my database has historic rows and I have made it so that a QVW stores by month QVDs - 2016-02.qvd and so on...

1. e.g. I want a qvw 1st of March I want to read februarys qvd previous month so to speak.

2. Later when that's done my plan is to adding filters in nprinting and from the qvw pick an object.

Maybe described bad sorry 😕

[andrespa]

Hi Niklas,

Answering your first question, you should write something like this on the script:

LET vLoadLastQVD = Year(Today())&'-'&Month(Today())-1;

LOAD *

FROM [yourQvdPath_$(vLoadLastQVD)]

Withe the second one I can't help you.

Hope it helps,

Andrés