topic Re: Help with formatting of chart/graph in QlikView

Help with formatting of chart/graph

Mon, 17 Sep 2012 09:42:26 GMT

Hi all,

I have an interesting chart that I need to create for a client.

-Like this one, as done in excel.

I currently have this expression which I use to create the background colours, in a straight-table for each cell value (Buffer Target %)

if((sum([Safety stock]) - Sum([Stock on Hand Quantity]))/sum([Safety stock]) <-0.00001

         , RGB(0,128,255) //Blue

         ,IF((sum([Safety stock]) - Sum([Stock on Hand Quantity]))/sum([Safety stock]) <= 0.33

             ,RGB(0,255,0) //Green

             ,IF((sum([Safety stock]) - Sum([Stock on Hand Quantity]))/sum([Safety stock]) <= 0.67

                ,RGB(255,255,138) //Yellow

                ,IF((sum([Safety stock]) - Sum([Stock on Hand Quantity]))/sum([Safety stock]) <= 1

                   ,RGB(255,128,128)//Red

                   ,RGB(0,0,0)//Black

                   )

                 )

              )

     )

So, this could be used to create the background colours on the chart.

Any ideas would be appreciated.

Re: Help with formatting of chart/graph

Mon, 17 Sep 2012 14:39:10 GMT

He,

It's not exactly clear what you're trying to achieve. But it seems to me that you have to layer objects above each other.

For eg. make a stacked bar chart, which shows the back ground color. You should fiddle with the bar distance and cluster distance.

Create a second transparant line graph and layer it on top of the other graph. With the same size. Remove the x-as and hide the y axis from this chart. By using ctr-shift you can change the size of the data part of the graph to mach the size of the bar graph.

I couldn't come up with a way to inverse the y-axis. Maybe somebody else has an idea for that.

Hope this helps.

Re: Help with formatting of chart/graph

Mon, 17 Sep 2012 15:28:35 GMT

Thanks! I'll give that shot.