Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Creator III
Creator III

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?