Filter not working when unchecking 'Keep Source Formats' on table-column

[mrwong]

Hi, 
Qlik NPrinting November 2020 Version: 20.39.3.0
I have an Excel template with multiple columns from one table, filtered on a column value.
The filter doesn't seem to apply to any columns where 'Keep Source Formats' is unchecked; why?
With Keep Source Formats, the Excel report was showing the numeric value for the timestamp/date columns, so I unchecked Keep Source Formats to specify the format; however, I end up with an Excel with extra unfiltered values in the columns unchecked.

[Lech_Miszkiewicz · Accepted solution]

Hi @mrwong 

I see what happens and I cannot explain it. 

All what I can say is that I assume something is wrongly configured:

• what is the version of NPrinting Server? (note that NPrinting Server, Engine and Designer MUST be on the same version)
• are you sure your qvw is fully supported?
  • no triggers?
  • no alternate states?
  • no webview?
  • etc... https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/GettingStarted/HowCreateConnections/...

If you still think this is a bug I think you should open support case as we would need more "hands-on" approach to troubleshoot this.

@Ruggero_Piccoli & @Frank_S - what do you think guys?

[Frank_S · Accepted solution]

HI @Lech_Miszkiewicz

You also asked some very important questions in your last update. We'll need to get that information from @mrwong.

@mrwong, it is critical to check these points mentioned by lech re unsupported items as this could very well be the issue.

The article he describes the unsupported items you need to check. 
These are similar for both QlikView and Qlik Sense. The chart id's in your snapshots indicate QlikView.

As such here is an article that you can use with video, that describes how to look for unsupported items.

• https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Unsupported-QlikView-Document...

Kind regards...

[Ruggero_Piccoli · Accepted solution]

Hi,

Please also note that Qlik NPrinting November 2020 is no more supported. Start by upgrading your installations of QlikView and Qlik NPrinting to a supported version (the latest is better) and test with it plus the suggestions from @Frank_S and @Lech_Miszkiewicz .

The "Keep source format" option is not related with filters behaviour and we not have similar know issues. If the issue persist after the upgrade and after checking the other suggestions please open a support ticket we everything we need to reproduce it.

Best Regards,

Ruggero

[mrwong]

Thanks Ruggero, Frank and Lech

[Lech_Miszkiewicz]

Hi, I see that you have marked our answers as solutions. Did you actually solve it and if you did what was the cause of the problem?

cheers