Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am fairly new to Qlik, but running into a couple issues when building report tasks.
Hi @JfrankGroundSystems ,
Report task filters can be picky with Year() and with timestamp vs date typing. The most reliable approach is to filter using a dynamic “current year” date range instead of comparing Year() values. Use an Evaluate condition like:
Opportunity.StartDate >= YearStart(Today()) and Opportunity.StartDate < YearEnd(Today()) + 1
If Opportunity.StartDate is a timestamp, use:
Floor(Opportunity.StartDate) >= YearStart(Today()) and Floor(Opportunity.StartDate) < YearEnd(Today()) + 1
Regarding your second question, yes, you can do per recipient filtering, but it depends on what you are using to distribute the report (Qlik Sense subscriptions vs NPrinting vs Application Automation). The typical pattern is: one recipient per row in a recipient list (email + the matching filter value), then the task applies that value as a selection/reduction so each person’s output is generated with their own filter.
Live and Breathe Qlik & AWS.
Follow me on my LinkedIn | Know IPC Global at ipc-global.com