Need duel color in my Qlikview bar chart, as i am using combo chart.

[sharu055]

Hi,

Using Sum of amount as bar and count Id in Line. i need the bra chart should sum of all the amount and if amount >=25000 should be in orange else in blue. please help

Data:

Amount               Date

12000                    Apr 07

26000                    Apr 07

16000                    Apr 07

6000                     Apr 07

21000                    Apr 14

6000                     Apr 14

46000                    Apr 14

need output as below

[ASEDavidSu]

Here's the example for you.

[sharu055]

Hi,

Thank for the response,

Actually i need the color change in single bar

[ASEDavidSu · Accepted solution]

formula>=25000

background color

if(sum({<“amount={=sum(amount)>=25000”}>}amount),rgb(255,128,64),rgb(0,128,255))

formula<25000

background color

if(sum({<“amount={=sum(amount)<25000”}>}amount),rgb(0,128,255), rgb(255,128,64) )

[sharu055]

Thanks, its working 

[sharu055]

@ASEDavidSu Hello, i hope your doing good. Could you please help me in further enhancement.

Actually in same data i have, i need rolling  5 week data from max week to display in the same chart.

and only Closed status should appear in the chart. should not alter for the Status open.  Can you help me.

Amount               Date             Week          Status

12000                    Apr 07         18                Closed

26000                    Apr 07            18                Closed

16000                    Apr 014           19               Closed

6000                     Apr 014             19               Open

26000                    Apr 21               20               Open

6000                     Apr 28                21              Closed

46000                    May 4               22               Closed

12000                    May 4              22               Open

36000                    May 11            23              Closed

16000                    May 11            23              Open

6000                       May 18           24             Closed

21000                     May 18          24             Open

6000                       May 25           25             Closed

46000                    May 25            25             Open