topic Re: Remove current Date's "month" from Script in QlikView

Remove current Date's "month" from Script

marcus_steggall — Tue, 10 Nov 2015 13:39:56 GMT

Hi everyone, hope you're all well.

Hopefully a quick easy one, which I can't seem to get working.

Basically, I want a line of code in the script, that will ignore Today date's month.

So for example, we are 10 days into November and if we refresh a dashboard, I want this to show all data upto end of October.

No point, in showing data just for the first few days of November.

This way, the dashboard can automatically refresh each month.... safe in the knowledge, the data is only upto last month.

Any help, would be much appreciated.

Have a good day.

oknotsen — Tue, 10 Nov 2015 14:43:46 GMT

Add a where clause to your load script:

where someDate < MonthStart(today())

sunny_talwar — Tue, 10 Nov 2015 14:51:24 GMT

With your sample data, try this:

LOAD Month,

Period_Start_Date,

Year

FROM

month.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Period_Start_Date < MonthStart(Today());

marcus_steggall — Tue, 10 Nov 2015 15:34:53 GMT

Thanks both, ahhh to the MonthStart function.

Much appreciated, just what i required.