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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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