Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like below in Qliksense dashboard. I want to show this as Pie chart in Qlik Nprinting Powerpoint template.
But I want the conditional coloring here that if Country=US then Red color, for Country=CA then Green...like this. So I am unable to do this conditional coloring in Pie chart in powerpoint/excel template. Please someone help me out here...
Country | Sales |
---|---|
US | 2000 |
CA | 1500 |
India | 1000 |
China | 500 |
Thanks,
Anil Jena
Ok so first things first create the pie chart but turn your country dimension into a master item.
You will be able to assign colours to your dimension values. US=red etc...
The great thing about this is the colours will apply across any chart that supports library colours.
Then create the pie chart and in colours use library colours.
Then you will be able to bring your chart image into nprinting.
Regards
Andy
Thanks Andy for the reply..But I don't want to use Qlik image in nprinting...want to use the powerpoint/excel functionalities there.
In that case youll be bringing the data in raw from a table and then building the chart using that defined data source and the capabilities of excel or PowerPoint. I've done it with piviot tables as you cannot bring them directly in nprinting but I've always let Qlik do its thing with the other charts.
I already did what you said above ..only issue is coloring part which I want that to be conditonally.
Like if Country=US then Red color, for Country=CA then Green...like this
Had a quick look around and it looks like you will struggle.
Pie chart colours based on conditional formatting of cells - Microsoft Community
Regards
Andy