topic Re: Last month qvw in QlikView

Last month qvw

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 17 Mar 2016 15:45:24 GMT

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