Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
Hi, solved, using triggers instead in QlikView when open 🙂
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.