Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

Resident Exists VS SQL IN Parameter

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

A got a excel with ordernumbers, like:

VaruOrderIDAntalPall
248248005141
224S120742
249249004991
225S120479

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?

 

Labels (2)
1 Solution

Accepted Solutions
johnan
Creator III
Creator III
Author

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

 

View solution in original post

3 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

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)

johnan
Creator III
Creator III
Author

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

 

Frank_S
Support
Support

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-...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!