Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 ?