topic Re: Barchart format in Qlik NPrinting

Barchart format

poooja — Tue, 17 Mar 2020 20:40:38 GMT

Hi Qlikies,

We are bringing bar chart into NPrinting power point report from qlik sense app and we need to remove the legends on the bar chart in the Nprinting template. Please see below image. we need to remove the highlighted legend. Please guide me to achieve this.

Any help would be appreciated.

Thanks!

Pooja

Re: Barchart format

Frank_S — Fri, 27 Sep 2019 20:06:24 GMT

Hi @poooja

In simplest terms, you can probably do the following to get the quickest results.

Clone/copy the chart
Disable 'legend' options from the cloned/copied chart and click 'done' to save your work
disable other not needed features in the 'presentation' menu option.

Name the chart appended with NP so you can find it easily in NPrinting.
Before the new chart can be used, reload the NP connection to the modified Qlik Sense app to allow the new chart to appear.
Add the new chart without legends to the NP report.

Hope this helps to guide you in the right direction...

Re: Barchart format

poooja — Fri, 27 Sep 2019 20:21:22 GMT

Hi Frank,

Thanks for your reply. My scenario is: User needs this bar chart with legends in qlik sense app. but in NPrinting we need to bring this chart without legend. In this case,

1. Please let me know if there is any option available without cloning the objects.

2. Is there a way i can hide the cloned copy in the dashboard when i publish it to the user.

Thanks,

Pooja

Re: Barchart format

Frank_S — Fri, 27 Sep 2019 23:06:53 GMT

Hi @poooja

The best I could find is this formula to use as a calculation condition in your chart properties/addons/data handling:

=WildMatch( OsUser() , '*ADMINISTRATOR*' )
ADMINISTRATOR is your NP connection identity. If the user that accesses the chart does not closely match, you get an error "calculation condition not met"

It's not perfect but you get the idea. Perhaps some else here is a better suggestion.

Have a good weekend...

Re: Barchart format

Lech_Miszkiewicz — Sat, 28 Sep 2019 06:37:12 GMT

From top of my head September version supports conteiners. You may want to have 2 charts in conteiner. One with legend for UI and another only for NPrinting without labels.

My suggestion though would be to build it directly in PowerPont charts:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Create-a-stacked-bar-chart-with-PowerPoint-Object/td-p/132870

Re: Barchart format

poooja — Sat, 28 Sep 2019 18:07:46 GMT

Thank you. I will check once we upgraded to the latest version.

Regards!
Pooja