Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

condition not working

Hi all,

here i create 1 chart take a dimension month

and my current month is july and my graph show me all 12 month data

my requirement is

if my month = current month then change the axes color

here i write this expression

if(wildmatch(Month,'Jul',red(),green())

in axes tab but is not working .

Any help.

1 Solution

Accepted Solutions
Not applicable

PFA the solution.

View solution in original post

16 Replies
tresesco
MVP
MVP

Correction needed:

if(match(Month,'Jul'), red(),green())

vipin_mishra479
Creator II
Creator II
Author

Hi tresesco

thanks for the reply

is not working

here i attached the application just for example

tresesco
MVP
MVP

Sorry, you can't color axes values with multiple colors as this expression can't refer dimension values.

vipin_mishra479
Creator II
Creator II
Author

is it correct,

but user want change axes color also.

SunilChauhan
Champion II
Champion II

try this dynamic one


if(Month=Month(today()),red(),green())

Sunil Chauhan
aveeeeeee7en
Specialist III
Specialist III

I have applied Tresesco Sir Code. It is working.

Match Condition.png

Not applicable

Is this what you want?

vipin_mishra479
Creator II
Creator II
Author

Hi Nag ,

is it ok for me also

but i want below of this chart change 'Jul' color also in axes.

vipin_mishra479
Creator II
Creator II
Author

thanks for reply deepak,

no is not correct for me

i want whole july part in chart is red like graph as well as axes also