Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

applying Colors in the bar chart

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

7 Replies
MVP
MVP

Re: applying Colors in the bar chart

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

consenit
Contributor II

Re: applying Colors in the bar chart

Hi there.

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

if

(

  sum

  (

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

  Expression1_Budget

  )

  <=

  sum

  (

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

  Expression1

  ),

  Red(),Green()

)

ecolomer
Honored Contributor II

Re: applying Colors in the bar chart

is that?

Not applicable

Re: applying Colors in the bar chart

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.

Not applicable

Re: applying Colors in the bar chart

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

ecolomer
Honored Contributor II

Re: applying Colors in the bar chart

Yes, this are the changes

p24.png

Not applicable

Re: applying Colors in the bar chart

Hi,

Thanks for all your support.

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

! !

Community Browser