topic Re: Resident Exists VS SQL IN Parameter in Qlik NPrinting

Resident Exists VS SQL IN Parameter

johnan — Sat, 16 Nov 2024 04:37:50 GMT

Hi, got a problem with varibles from my qlikview document to Nprint wordreport.

A got a excel with ordernumbers, like:

Varu	OrderID	AntalPall
248	24800514	1
224	S12074	2
249	24900499	1
225	S12047	9

Okay, then i do a resident load and use where Exists (OrderID) from the EXCEL.

Everything works fine and Nprint cycle the worddocuments.

But all the variables from QlikView not showing in attached mail from N-Print.

If i do SQL instead of Resident with Exists with where IN clause and set the ordernumbers, then it's working fine.

where Column IN ('24800514','24800513') WORKS

Resident TABLE where Exists (OrderID, Name) NOT WORK

Why?

Re: Resident Exists VS SQL IN Parameter

jfkinspari — Tue, 29 Jan 2019 13:44:11 GMT

I'm thinking you want to change the order of the parameters in the exists formula, as you want to filter rows in the field Name based on values from Excels OrderID column.

Resident TABLE where Exists (Name, OrderID)

Re: Resident Exists VS SQL IN Parameter

johnan — Tue, 29 Jan 2019 16:02:39 GMT

Hi, solved, using triggers instead in QlikView when open 🙂

Re: Resident Exists VS SQL IN Parameter

Frank_S — Tue, 29 Jan 2019 16:25:16 GMT

Please note that using QV triggers in QVWs intended for reporting purposes is not supported and will cause you other reporting issues.

https://support-cdn.qlik.com/articles/000026081

If you have having issues with variables in your NPrinting reports, check the following solution which 'may' apply to your situation. Scenario two may be most applicable.

https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/Troubleshooting/Variables-dont-expand-before-calculating.htm