topic Re: NPrinting - Create formula which returns a string in Qlik NPrinting

NPrinting - Create formula which returns a string

jrl — Sat, 18 Jan 2020 01:58:55 GMT

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.

Re: NPrinting - Create formula which returns a string

Ruggero_Piccoli — Mon, 20 Jan 2020 15:02:07 GMT

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

Re: NPrinting - Create formula which returns a string

afbraga1 — Mon, 20 Jan 2020 15:06:36 GMT

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

Re: NPrinting - Create formula which returns a string

Lech_Miszkiewicz — Mon, 20 Jan 2020 22:23:27 GMT

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

Re: NPrinting - Create formula which returns a string

jrl — Tue, 21 Jan 2020 21:08:10 GMT

Ugh! Single quotes! Of course.

Thank you.