topic Re: Mini Bar Chart - Can you Rag Colour?? in QlikView

Mini Bar Chart - Can you Rag Colour??

Wed, 14 Oct 2015 10:46:16 GMT

Hi All

Can you RAG colour a Mini Bar Chart?

Also if you can - Can the Rag be based on differing Target values per Row?

i.e.

Row 1 target> 2=Green, Red,

Row 2 >1500=Green, Red.

I havent found a way of Rag the rows at all yet and am needing tofind how to do this ASAP

Many Thanks In Advance

Re: Mini Bar Chart - Can you Rag Colour??

avinashelite — Wed, 14 Oct 2015 10:49:37 GMT

got to expression tab in the chart properties> click on the + mark on the expression >click on the background color

here if(sign(sum(amount)=-1,RED(),GREEN())

Re: Mini Bar Chart - Can you Rag Colour??

Wed, 14 Oct 2015 11:17:58 GMT

Hi Thankyou for your reply

This isnt working for me they are all coming back as Green- its as if its assessing the overall RAG for the expression but not per month in the mini chart for the individual row data

Can you post a working example please?

Re: Mini Bar Chart - Can you Rag Colour??

avinashelite — Wed, 14 Oct 2015 11:22:01 GMT

Sorry, I was think in the actual bar chart . Your trying it in the min chart ok, can you post you app will check