Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having an issue with NPrinting wherein a filter is causing all possible values to be printed, rather than the values specified.
The report I'm trying to create cycles by Sales Branch, and on each branch it brings back all transactions that were priced below a certain margin. One of the tables has a filter that's causing the problem. The filter basically says "Damaged stock flag is equal to No", and turning this filter on results in displaying every single transaction for every branch in the country, despite the fact that it is set to cycle through each branch individually.
I've tried switching the filter to "Damaged stock is not Yes", but the same issue occurs. I've also made sure that the filter is not being duplicated in the report or the task. The filter is only being applied on the table used in the report editor.
Any help would be much appreciated.
Thanks,
Henry
hm, that is normal QlikView behaviour, it is the same as when you click into grey fields in a listbox, then the selection will be reset.
I think you have 2 options:
1) change the order of your filters and disable verify filters but that is risky....
2) add dummy data so that every selection is possible: Generating Missing Data In QlikView
did you activate "verify filter"`?
Normally this happens if none of the values is seletable.
Hi Robin,
Just tried enabling 'Verify filter', the same issue occurs I'm afraid.
If it helps, the filter seems to linger for a long time before proceeding to the next one
Actually, I tried verifying all filters associated with that table, and one of them does return no records.
In that case, is there no way that I can tell it to ignore a filter if there are no records? If I'm producing a report with 600 branches, there are going to be a few branches that do not fit the criteria for this section of the report, can't nprinting just leave it blank?
hm, that is normal QlikView behaviour, it is the same as when you click into grey fields in a listbox, then the selection will be reset.
I think you have 2 options:
1) change the order of your filters and disable verify filters but that is risky....
2) add dummy data so that every selection is possible: Generating Missing Data In QlikView
Maybe you can create a condition Conditions ‒ Qlik NPrinting to avoid to produce the report when a table as no rows after applying a filter.