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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-14 03:43 PM

Using NPrinting 17.6 (November) getting error using formula in Task Filter

Hi,

We're using QlikSense 3.2 R2 and NPrinting 17.6, and I'm trying to create a dynamic task filter so I don't have to update the filter values every week. My formula works correctly in the app (shows last week's week number concatenated to the year), but when I try to use in the NPrinting task, I get this error:

Execution for task b2a113d5-dabc-407f-9bbd-9e56d2bb2dea failed for an exception System.Exception: Failure Filter Materialization, fields with formula: F\WeekYear - Sunday Start'. No report will be generated.

I searched the discussions here, and read the Release documentation, though I could only find June's. My formula is:

=(([Week - Sunday Start])-1)&'-'&[Year] 

I'd appreciate any suggestions anyone might have; I'm hoping it's something stupid in my formula.

Thanks,

Judy

785 Views
0 Likes
0 Replies