topic Re: N-Printing stacked bar chart in Qlik NPrinting

N-Printing stacked bar chart

Anonymous — Mon, 03 Aug 2015 19:18:56 GMT

How can I show minimum stacked bar value inside segment using N-Printing ? Please find attachment.

Re: N-Printing stacked bar chart

Mon, 03 Aug 2015 19:46:56 GMT

My recommendation is you build a bar chart that looks like the attached using the options of showing data points and also add an expression for total. You can then create text boxes that calculate your percentage.

Bring the barchart in as an image and it should look just like what it does in Qlik. Then add the text boxes as iamges above the bars you want from the bar chart iamge. You can also use NPrinting formulas for the percentage and place those in the appropriate cells for alignment

Re: N-Printing stacked bar chart

Stephen_Jasionowski — Mon, 03 Aug 2015 20:02:41 GMT

Praveena -

You also create this chart using a stacked bar chart in the PixelPerfect template editor. You'll see that a side-by-side stacked bar chart is one of the options:

Once you add the chart and identify the data series, you're also able to format the point labels in the way that you want. All of these options can be configured from inside the chart wizard.

Here is an example of how to set advanced formatting inside a PixelPerfect chart: How to Create a Well Formatted PixelPerfect Chart – Customer Feedback for Vizubi

Re: N-Printing stacked bar chart

Anonymous — Mon, 10 Aug 2015 21:31:47 GMT

Hi Stephen,

I can able to follow steps but could not able to create stacked bar with quarter and region as dimensions for expressions.

Where Can I add dimensions one as primary and other for stacked?

Re: N-Printing stacked bar chart

vishsaggi — Sun, 23 Aug 2015 06:38:52 GMT

hello Praveena,

I was also looking for the same requirement, and i am facing the same i could not see the stacked bar using two dimensions. Did you happen to resolve this issue please let me know??

Stephen: Any comments or ideas on this please???

Appreciate your help.

Thanks,
V.

Re: N-Printing stacked bar chart

Anonymous — Sun, 23 Aug 2015 17:20:59 GMT

It is not possible to define two dimensions as columns and expression as series in N-Printing tables.

So far, N-Printing16.XXXXXX did not have option for two dimensions using Tables.

Instead, you need to do workaround by creating expressions incorporated with stacked dimension values of 2 dimensions. by this you will have only one dimension. So, this will solve problem.

PS: It looks painful and messy to create expression for each and every dimension value if it more than 5.

Re: N-Printing stacked bar chart

vishsaggi — Mon, 24 Aug 2015 10:26:20 GMT

Thanks Praveena for you prompt reply would you mind elaborating little bit the below statement as I went a little off the track on this in understanding.

"expressions incorporated with stacked dimension values of 2 dimensions. by this you will have only one dimension"

Appreciate your help.

Thanks,
V.