NPrinting - Create formula which returns a string

[jrl]

I can't seem to create a formula in NPrinting that returns a string.  Every time I preview the template, the formula just shows "-".  Is there a specific function in QlikView/NPrinting that will allow the string to evaluate properly?

The specifics of the issue are:

- I have a variable called vReportingQuarter = "2019Q3".

- I'm attempting to convert the vReportingQuarter variable to a string like "September 30, 2019".

- I've attempted to build a formula like: =PICK(RIGHT(vReportingQuarter,1),"March","June","September","December"), but when I add this to the template, it just evaluates as "-"

Any help would be appreciated.

[Ruggero_Piccoli · Accepted solution]

Hi,

Yes, Qlik NPrinting supports QlikView/Qlik Sense formulas that return strings. Formulas must return a single value, so a single string is ok.

In your case, did you test the formula in QlikView before to insert it into Qlik NPrinting? Qlik NPrinting doesn't evaluate the formulas, it send them to QlikView/Qlik Sense and wait for the results. 

I tested your formula in QlikView and I needed to modify it to 

=PICK(RIGHT(vReportingQuarter,1),'March','June','September','December')

in order to get the correct result in QlikView.

Best Regards,

Ruggero

[afbraga1]

Hello Jrl,

Why don't you code the expression as you want in QlikView and then just import to NPrinting?

Which type of report are you trying to build? Excel, Pixel Perfect, PowerPoint?

Best Regards,

André Braga

[Lech_Miszkiewicz]

Hi @jrl

 @Ruggero_Piccoli pointed you into right direction. The other factor why your formula may not work is the definition of your variable. What is it? Is the value set to 2019Q3 or is it a an expression which calcualtes and returns this value. In such case you would have to expand it using $ sign 

=PICK(RIGHT($(vReportingQuarter),1),'March','June','September','December')

hope this helps

[jrl]

Ugh!  Single quotes!  Of course.

Thank you.