100% Bar chart with Cyclical dimension

triekong — Thu, 21 Sep 2017 21:03:57 GMT

hi All,

i created 100%stacked bar charts using 100% Stacked Bar Graph.

it works great but i have a new requirement to add a cyclical dimension to the chart.

so my new dimensions are:

1. CategoryGroup: -Category0 -Category1 -Category2

2. SLA Breach

To be able to create the 100% chart, the formula used was : count((number))/Count(TOTAL <Category1> number)

i need the 'Category1' portion of this formula to change when the dimensions are changed, so that the bars will always be equal to 100% even when dimension has been changed.

Let me know if anyone has a workaround for this/ is it possible.

Re: 100% Bar chart with Cyclical dimension

sunny_talwar — Thu, 21 Sep 2017 22:36:44 GMT

Try this

Count(number)/Count(TOTAL <$(='[' & GetCurrentField(CategoryGroup) & ']')> number)

topic 100% Bar chart with Cyclical dimension in QlikView

100% Bar chart with Cyclical dimension

Re: 100% Bar chart with Cyclical dimension