Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
anat
Master
Master

Monthend data for history and daily data for current year

in data base i have data from 01-01-2020 to till date

when loading data into qlik,

1. for 2020 and 2021 need to take only month end data like 31-01-2020,29-02-2020 ...........31-01-2021......31-12-2021

for previous years need to load only month end data 

2.for current year daily data....

note:incremental load not in place ,every time need to load all data.

1 Reply
anat
Master
Master
Author

i am trying like below:

test:

load * from table where match(datefield,monthend(datefield)) and year(datefield)<year(today());

concatenate

load * from table where year(datefield)>=year(today());

 

is this right approach ?