Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikies,
Please guide me if we can achieve the below thing in NPrinting.
Can we bring stacked bar chart into PowerPoint native chart?
Any tips will be helpful.
Thanks!
Pooja
Ok, I see what you are trying to do.
You actually wanted to use QlikSense stacked barchart with 2 dimensions and 1 measure and use it as a table tag in NPrinting. To be frank I have not tested if this is possible or not..... but regardless.... this object would export data in the format which is not the one required for native powerpoint stacked barchart as you will get 2 columns with dimension values and one column with measure.
If you look closely at tutorials for PPT native stacked bar chart in NPrinitng you will see that you need to have one dimension which will be supporting X-axis labels (in your example caountry) and measures which will support stack part of the chart (in your example measure for each Department), hence you need a table/chart in QlikSense built in different way (probably using set analysis).
Short answer is you need to build one more object in Qlik Sense which will support your data for NPrinting. I would then use table object for this purpose!
As I always say - there is a lot of planning involved in building NPrinting reports and I usually suggest to have dedicated Qlikview or Qlik Sense apps supporting them so then you don't have to worry about charts which are required for NPrinitng to work most efficiently!
before posting questions use at least google search:
this is what comes up when i typed in google "build stacked bar chart powerpoint nprinting"
so to answer your question:
Yes - you can build stacked bar chart using native PPT charts
Hi Lech,
Thanks for your response. I missed mentioning that I am not able to bring the chart as a table in the PowerPoint template as my expressions are in the Master items. I am able to bring it when the expression are direct and not in the Master item.
Thanks!
Pooja
This is very strange what you are saying. I just tested it now i had no issues adding object built of master items to my power point template.
I am not aware of any limitation which would prevent objects built of master items to be pulled in as a table tag in NPrinitng PowerPoint. I guess you just missed something, maybe you did not refreshed metadata?
Or if my understanding is wrong, maybe provide screenshots of the steps you are taking and highlight where it is not working for you.
regards
Lech
Hi Lech,
Which version you have used? We are using NPrinting 19 April 2019 version. I am unable to bring stacked bar chart as table in power point. I am able to bring this object image. but not as table.
what could be the reason. Is this version limitation? any idea?
Thanks,
Pooja
Ok, I see what you are trying to do.
You actually wanted to use QlikSense stacked barchart with 2 dimensions and 1 measure and use it as a table tag in NPrinting. To be frank I have not tested if this is possible or not..... but regardless.... this object would export data in the format which is not the one required for native powerpoint stacked barchart as you will get 2 columns with dimension values and one column with measure.
If you look closely at tutorials for PPT native stacked bar chart in NPrinitng you will see that you need to have one dimension which will be supporting X-axis labels (in your example caountry) and measures which will support stack part of the chart (in your example measure for each Department), hence you need a table/chart in QlikSense built in different way (probably using set analysis).
Short answer is you need to build one more object in Qlik Sense which will support your data for NPrinting. I would then use table object for this purpose!
As I always say - there is a lot of planning involved in building NPrinting reports and I usually suggest to have dedicated Qlikview or Qlik Sense apps supporting them so then you don't have to worry about charts which are required for NPrinitng to work most efficiently!
Hi Lech,
Thank you so much for your detailed explanation.This helps me to work around in different way.
Thanks!
Pooja