Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Using multiple IF statement on chart background colour

I have the following statement to change colour of one column of my chart:

=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),RGB(0,128,0))


Can you please advise how I can add a nested / multiple IF statement to change another column in the same chart, a DIFFERENT colour.  So, I will have two columns which will stand out in different colours to the rest and each other.  Thanks guys!

Labels (4)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

hi 

=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),
    if(Calendar_Year_Month='2020-08',ARGB(200,200,200,0), RGB(0,128,0)))

View solution in original post

2 Replies
Highlighted
Partner
Partner

hi 

=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),
    if(Calendar_Year_Month='2020-08',ARGB(200,200,200,0), RGB(0,128,0)))

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you!