Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Anyway to Filter data on reload task (not reduce)?

I have a document that needs to be published and emailed in current month and previous month states.   The document contains (Previous months) data as well as current month. When previous month is chosen, it should so last month as current and previous month as current month - 2).   If I use the reduce data feature on the task, and set date= last month flag, it removes all data that isnt equal to last month, so the Previous month no longer calculates. Is there anyway to filter data rather than reduce? Or alternatively, set a variable in a task that would set today as last month?

1 Reply

Hi @bcraymond, you can try adding another field to the dates to use as a flag (current and previous month dates will be flagged), so you can try reducing data based in that flag