Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

canmarroig
New Contributor II

How limit loading data in script

Hi, i need to limit data loading only for current year on the previous month, for instance today I need only August data

I've tried to set a where condition:

where NUM(month(DATA)) <= NUM(month(today())-1); but this set on 8 (August) data also in 2016, 2015, ecc.

Can you help me?

1 Solution

Accepted Solutions

Re: How limit loading data in script

Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)

2 Replies

Re: How limit loading data in script

Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)

balar025
Contributor III

Re: How limit loading data in script

As i understand from query is ,

You need full data for previous years but for current year, you want only current month data.

Is this the case?