Discussion Board for collaboration on Qlik NPrinting.
In a Power Point report I want to show a figure in a text field. As the figure needs a certain color, depending on its value I have used a straight table for just this figure. The table has the following settings:
Layout: Shadow intensity: no shadow
Layout: Border width 0
Style: Cell backgroud color transparency 100%
Style: cell borders transparency: 100%
Vertical Dimenstion Cell Borders and Vertical Expression Cell Borders are not selected.
When I use the table in NPrinting Power Point the cells still have borders although I select "keep source format" (see attached screenshot)
Is there any way to get rid of the border lines?
Could you not use Text object or KPI in Qlik or to have even more flexibility you can use the 'Variables' or 'Formulas' option in NPrinting.
Just look below the tables
Transparencies cannot always be properly used with office templates as office does not support them - right?
I do suggest use the solution Robert mentioned. If you still want to use cell you may use colour of border and background which will blend with background of your report - remember not to use transparency (just regular RGB colours)
Thanks for your feedback @robert_mika
Is there any option to include an expression for the font color in a variable depending on the figure? That was the reason why I was not using the formulas or variables.
There is no formula but there is workaround which I explained in this post:
would that be helpful?
Thanks @Lech_Miszkiewicz for the info regarding the transparency. I change all the settings for borders and background (including all custom format cells) to an actual color but the border lines still come out in grey instead of the chosen color.
With the formula / variable solution I have the problem that the font color needs to be set based on the figures and I do not know how to include that in my expression. If you have a suggestion on how to do that, it would absolutely solve my problem. Thanks!
I am going to do some more testing on that later this week and can come back to you later (testing of using cell and keep source format).
Thanks @Lech_Miszkiewicz , much appreciated! By the way, I did some additional testing and it seems that there is no way in general to set the color of borderlines in QlikView and keep the source format in NPrinting. At least I did not manage