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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Concatenate table based on criteria

HI,

i have a TableC that i would like to concatenate to my Master Sales Table.

I would like to concatenate based on a criteria which follows:

  • if Day (based on Today date) is between 1-3 then load all data from TableC where SalesDate> Month Start Date of the previous month
  • if Day (based on Today date) is between 5-31 then load all data from TableC where SalesDate> Month Start Date of the current month

Which is the right syntax to do this?

Thank you

1 Reply
marcus_sommer

Maybe with something like:

load * from TableC where SalesDate >= monthstart(today(), (day(today())<=3));

- Marcus