Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I had created a new Nprinting task, using an existing report base. The only exception was to add a new filter called: Partner or Roadmap: PSM Chargeable, PSM Non Chargeable. This filter is working on other tasks. Following the creation of the task, I ran it for a test. However, it failed to generate and gave an error of:
WARN: error during report generation: Invalid selections are applied to chart TAIDR Project List: Filters: [Fields: [Name: F\Partner or Roadmap,
Below is the Engine log:
Date and time Level Description
September 16, 2020 3:14:51 PM Info Starting content resolution for report ea939b56-7c51-4692-ba00-bebb5162aa3d
September 16, 2020 3:15:04 PM Info Finished content resolution for report ea939b56-7c51-4692-ba00-bebb5162aa3d
September 16, 2020 3:15:04 PM Info Starting content production
September 16, 2020 3:15:04 PM Warn WARN: error during report generation: Invalid selections are applied to chart TAIDR Project List: Filters: [Fields: [Name: F\Partner or Roadmap, ConnectionId: 8b26b7f1-fe38-4975-8aa2-6928643ca93e, Values: [String:PSM – Non-Chargeable, String:PSM – Chargeable], Override: False, Void: False], Void: False Fields: [Name: F\Budget Year, ConnectionId: 8b26b7f1-fe38-4975-8aa2-6928643ca93e, Values: [Evaluate:=Year(Today())], Override: False, Void: False], Void: False Fields: [Name: F\Delivery Report Flag, ConnectionId: 8b26b7f1-fe38-4975-8aa2-6928643ca93e, Values: [String:IT, String:Technology, String:GDO, String:N&SO, String:T&I], Override: False, Void: False, Name: F\Exe Summary Corona Flag, ConnectionId: 8b26b7f1-fe38-4975-8aa2-6928643ca93e, Values: [String:Yes], Override: False, Void: False], Void: False], Bookmark: , Void: False
Can someone please tell me what's this error??
Regards
Maurice Bruns
Hi @boopeshj
no, I don't suggest that. I cannot suggest anything without seeing it. All what I mean is that you need to model your data model so the filters can be applied and won't exclude themselves. This can be done, but it all depends on what filters are being applied and what combinations always need to exist so filter does not fail.
It does not mean that you need to keep those dimensions in separate tables. you may also concatenate particular combinations to fact table without including fields used in measures.
Hi,
error is self explanatory - WARN: error during report generation: Invalid selections are applied to chart TAIDR Project List: Filters
Whatever you have done with the filter NPrinting is not able to apply it. Typical issues are:
More about data type and pitfalls here:
1.) https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
3.) https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
cheers
Thanks (so far)
With regards to: 'selection cannot be applied and returns empty set'
In my case, i have 10 tab sheets in the report; with only 3 tab sheets that return an empty set. How can i ensure that i can generate the report if the the remaining 7 tab sheets have data?
Well. That is more of a design and development question, isnt it?
I dont know your data model in QlikView app, i dont know your template and report setup. If you experience such issues it means that report design was not planned and may require changes...but we cannot help more if we cannot see that exact scenario you are in
Also i think that your 3 sheets are not able to apply filter You are trying to apply. It is different scenario than no data in charts from selection-it actually means that other fields you are selecting are not allowing you to apply the selection fully.
typical workaround for that is to create dummy records in QlikView datamodel for the dimensions Used in selections so that selection can be applied but will not link to any factual data
@Lech_Miszkiewicz When you mean a Data Model Issue, Do you suggest the fields used in the filter should be separate Dimension tables ?
Hi @boopeshj
no, I don't suggest that. I cannot suggest anything without seeing it. All what I mean is that you need to model your data model so the filters can be applied and won't exclude themselves. This can be done, but it all depends on what filters are being applied and what combinations always need to exist so filter does not fail.
It does not mean that you need to keep those dimensions in separate tables. you may also concatenate particular combinations to fact table without including fields used in measures.