topic Re: applying Colors in the bar chart in QlikView

applying Colors in the bar chart

Mon, 22 Jun 2015 19:38:03 GMT

Hi,

I would like to apply the color on the actual bar in the chart based on the budget value.

if the actual is greater than or equal to budget value, than the color of the actual bar is in green else its in red.

I tried the expression, but its not working while using two dimensions.

kindly help me to resolve this issue.

thanks in advance.

thanks,

Gopinthan

Re: applying Colors in the bar chart

maxgro — Mon, 22 Jun 2015 19:49:45 GMT

I think you can remove the dimension Trx_Flag and get the color

Re: applying Colors in the bar chart

consenit — Mon, 22 Jun 2015 19:54:46 GMT

Hi there.

Try this expression for the background color and delete the field Trx_Flag from the dimensions.

(

sum

(

{$<Trx_Flag={'Budget'}>}

Expression1_Budget

)

sum

(

{$<Trx_Flag={'Actual'}>}

Expression1

Red(),Green()

)

Re: applying Colors in the bar chart

ecolomer — Mon, 22 Jun 2015 20:02:06 GMT

is that?

Re: applying Colors in the bar chart

Tue, 23 Jun 2015 06:00:26 GMT

Hi,

Thanks for all your reply.

Please find the attachment, which shows the reason of the dimension required in the bar chart.

Thanks in advance.

Re: applying Colors in the bar chart

Wed, 24 Jun 2015 13:14:47 GMT

Hi Enrique,

I think this one is working. But I am not able to figure out changes you did.

If you don't mind, can you please explain me?

Thanks,

Aakash

Re: applying Colors in the bar chart

ecolomer — Wed, 24 Jun 2015 15:42:18 GMT

Yes, this are the changes

Re: applying Colors in the bar chart

Thu, 25 Jun 2015 07:53:08 GMT

Hi,

Thanks for all your support.

Finally I got the solution, here with i attached the document FYR.

! !