topic Re: Text by filter in a PowerPoint report in Qlik NPrinting

Text by filter in a PowerPoint report

Amit_B — Fri, 02 Feb 2024 12:42:22 GMT

Hi,

I created a PowerPoint report with about 50 slides. All the slides show data on a specific supplier that is defined in a filter that is updated manually according to the supplier that is required.

The only thing I can't do is to create a kind of textbox with the supplier's name.
I tried with a table but I can't delete the header, using a page doesn't work for me either because the name is not dragged to the slide.
Any ideas how to do this?

Thanks!
Amit.

Re: Text by filter in a PowerPoint report

Digvijay_Singh — Fri, 02 Feb 2024 12:50:13 GMT

It appears Supplier Name is unique for a slide, so if you create and drag a new formula with Supplier Name field at the top of a slide should work or you can create a new text box at the top of the slide and write <Supplier Name field> inside the angle bracket.

Re: Text by filter in a PowerPoint report

Amit_B — Fri, 02 Feb 2024 14:19:58 GMT

Thanks for the response.

I will try to create a formula, maybe with GetSelectedValue.

We tried to create a PowerPoint text box with the field as you mentioned but it just shows it as text and not as a formula.

Re: Text by filter in a PowerPoint report

Digvijay_Singh — Fri, 02 Feb 2024 14:54:43 GMT

I meant like this -

Re: Text by filter in a PowerPoint report

Lech_Miszkiewicz — Sat, 03 Feb 2024 00:05:23 GMT

Hi @Amit_B

Are all 50 slides for 1 suppliers defined in filter?
Why Page does not work? Why you dont drag supplier name to the slides? Either you dont explain your scenario right or you doing something wrong. Providing us with some screenshots of how you designed your template and some high level description of your model would help understanding issue.
Using Page would be the easiest obviously but other alternative would be to create a variable vNP_Supplier_Name and you could use that variable on each slide and if all 50 slides are for the same suplier then you could just just set it also in your NPrinting filter where you could put whatever name you like for that variable and it would just display it.

Other required information:

Problem here is that we dont know how you build it and why the very simple solution does not work for you.
We also dont know if you apply filter on individual objects or on whole report or task?
- Applying your filter on whole report would allow you to use variable or formula like:
  - Concat(Distinct [Supplier Name])
  - or Only([Supplier Name])
- note that if it was variable it would have to have "=" sign like : "=Concat(Distinct [Supplier Name])" or "=Only([Supplier Name])" as variables will not expand as documented on https://help.qlik.com .

Bottom line: I am sure there is a super easy solution - it is just not clear what you do and how you do it because information we have is too vague.

cheers