QlikView dollar-sign expansion not showing values in NPrinting

[sten_lomme]

We're having issues that values of QlikView expressions using dollar-sign expansion is not returning any values when loaded to an NPrinting report.

Expressions such as below, does not return any values in NPrinting:
Sum([Subscription value $(vSelectedCurrency)])

But hard coding the field value return values fine in NPrinting:
Sum([Subscription value USD])

Is there any way around this issue?

Duplicating report objects and moving away from dynamically changing currency is not an option.

Hopefully there is an easy fix...

[Lech_Miszkiewicz]

Your scenario is not clear and would need proper description of scenario.

• What is your variable definition?
• How do you pass value to that variable?
  • Is it by field selection - expression in variable definition passes through field value 
  • Is it variable set in script? 
  • Is it variable set in UI by buttons or input box?
• How d you do above in NPrinting?
  • are you applying it as filter (variable or field)
• Are you using OnDemand where UI variable inputs are not supported?

I assume your variable requires selection to pass through value. That selection will be cleared when report is generated via task/preview and would have to be applied as NPrinting filter. 

[David_Friend]

@sten_lomme what version of Qlikview and nprinting are you using?

This should work if you are following: 

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Troubleshooting/Variables-dont-expan...

[Lech_Miszkiewicz]

Hi @David_Friend - i believe in this case requirement mentioned by you does not apply as we are talking about formulas/expressions in Nprinting. 

[sten_lomme]

Thanks guys!

The dataset contains two fields with different values:

- [Subscription value NOK]
- [Subscription value NOKBUD]

The expressions are defined in the QlikView load script as follows:

LET vCalSubsValueEnd = 'Sum({<FactType={SubscriptionFact}, >} [Subscription value ' & Chr(36) & '(vSelectedCurrency)])

Based on a selection by the user in the UI, the proper value of "vSelectedCurrency" is used. Hence using the correct value to display.

The resulting Qlik expression below does not work in NPrinting:

Sum({<FactType={SubscriptionEndFact}>} [Subscription value $(vSelectedCurrency)])

But changing the Qlik expression to below works fine in NPrinting:

Sum({<FactType={SubscriptionEndFact}>} [Subscription value NOKBUD])

Let me know if you need more info.

[sten_lomme]

We are running NPrinting May 2022 SR4

[Lech_Miszkiewicz · Accepted solution]

Yes we need more info as i mentioned in my previous post:

• how is that selection done by user ?
•  is it by field selection
• is it by variable input

and as mentioned in my previous post you would have to replicate that selection first by applying nprinting filter (to replicate user action) - are you doing it?

Lastly-are you maybe using OnDemand report generation which would not support variable inputs?

so take your time, read through my questions and provide as detailed as possible answer to all of them. Thanks

[sten_lomme]

Selection is done by field selection. Thought I already tried this. But now it works. Thanks for guiding in the right direction!