Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
balar025
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?