topic Re: Formula into a word object ? in Qlik NPrinting

Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 08:01:41 GMT

Hi,

I would like to know if it's possible to have a formula into a word object ? (form such as circle or square)

I tried, but it doesn't work for me. I don't get the result of the formula into the form..

Kevin

Re: Formula into a word object ?

Anil_Babu_Samineni — Wed, 09 Aug 2017 08:09:51 GMT

Question not clear. What your intention to achieve? Like this. If not please draw a neat sketch and share with us

Re: Formula into a word object ?

Ruggero_Piccoli — Wed, 09 Aug 2017 08:21:36 GMT

Hi,

If you add a QlikView or Qlik Sense formula in the Formulas node of a Word template and drag and drop it into the template it works. See Formulas ‒ Qlik NPrinting.

Maybe I don't have understand where you want to place the formula. Could you post a template screenshot?

Best,

Ruggero

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 08:26:20 GMT

Yes I want something like that.

But when I put the formula (with tags like <Formula>) into the object, I don't get the result after previous.

Have you done that in a word template ?

Kevin

Re: Formula into a word object ?

Ruggero_Piccoli — Wed, 09 Aug 2017 08:37:16 GMT

Please check that you have selected the correct connection when you create the formula.

If the formula uses fields form connection1 but you selected connection2 the result will be empty.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 08:45:33 GMT

No it's ok.

I don't have issue to get the result if I put the formula into word.

The problem is when I put the formula into an object (such as circle), then it doesn't give me the result.

Kevin

Re: Formula into a word object ?

Ruggero_Piccoli — Wed, 09 Aug 2017 08:49:31 GMT

It is not clear to me what do you mean with "put the formula into an object (such as circle)".

Could you post a screenshot?

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 09:10:17 GMT

Here is an example

Re: Formula into a word object ?

Anil_Babu_Samineni — Wed, 09 Aug 2017 09:12:18 GMT

What formula you tried?

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 09:14:48 GMT

Nevermind. Because this formula works into word. But doesn't work into the shape.

Re: Formula into a word object ?

Anil_Babu_Samineni — Wed, 09 Aug 2017 09:16:43 GMT

When you talk about Word, How you are doing this with Qlikview. Are you trying this same as mine?

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 09:25:30 GMT

Yes, I think I'm doing the same... (Right click on the shape / add text)

Below, an example of formula :

=sum({<ANNEE_DE={"$(=max(EXERCICE))"},SECURITE_PROGRAMME={'Nombre*'}>} SECURITE_REALISE)

Which version of Nprinting are you using ? Which version of Word ?

Kevin

Re: Formula into a word object ?

Anil_Babu_Samineni — Wed, 09 Aug 2017 09:29:13 GMT

N printing 17.3

Office 2016

Re: Formula into a word object ?

Ruggero_Piccoli — Wed, 09 Aug 2017 09:37:59 GMT

Did you checked if there are some specific errors in the logs?

Re: Formula into a word object ?

woutermak — Wed, 09 Aug 2017 12:25:15 GMT

Is it an option to work with transparency? You create a shape with transparency. You can put the text behind the object.

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 12:30:09 GMT

I dit that at the beginning but I had an issue by doing that. I have other shape next to the first shape. So the second formula can be shift out of the circle (depend of number of characters in the result of the first formula)...

Kevin

Re: Formula into a word object ?

woutermak — Wed, 09 Aug 2017 12:42:08 GMT

Did you also tried the more lay-out options and turned of the move object with text option?

Re: Formula into a word object ?

kevinchevrier — Wed, 09 Aug 2017 12:44:42 GMT

I can't try this solution during at least 1 week. I'll keep you in touch. Do you already have try this solution ?

Kevin

Re: Formula into a word object ?

woutermak — Fri, 11 Aug 2017 09:16:40 GMT

Not yet...

Re: Formula into a word object ?

kevinchevrier — Tue, 29 Aug 2017 13:21:03 GMT

Hello,

It's OK since I update NPRINTING with june 2017 release and update Office 2013 ==> 2016.

Thank you for your answers and the time you take for this issue.

Kevin