Formula into a word object ?

[kevinchevrier]

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

[Anil_Babu_Samineni]

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

[kevinchevrier]

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

[Anil_Babu_Samineni]

N printing 17.3

Office 2016

[Ruggero_Piccoli]

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

[woutermak]

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

[kevinchevrier]

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

[woutermak]

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

[kevinchevrier]

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

[woutermak]

Not yet...

[kevinchevrier · Accepted solution]

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