topic Re: Re: Re: condition not working in QlikView

condition not working

vipin_mishra479 — Thu, 03 Jul 2014 08:54:25 GMT

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.

Re: condition not working

tresB — Thu, 03 Jul 2014 08:56:18 GMT

Correction needed:

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

Re: Re: condition not working

vipin_mishra479 — Thu, 03 Jul 2014 09:03:14 GMT

Hi tresesco

thanks for the reply

is not working

here i attached the application just for example

Re: Re: Re: condition not working

tresB — Thu, 03 Jul 2014 09:06:23 GMT

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

Re: Re: condition not working

vipin_mishra479 — Thu, 03 Jul 2014 09:16:21 GMT

is it correct,

but user want change axes color also.

Re: condition not working

SunilChauhan — Thu, 03 Jul 2014 09:17:22 GMT

try this dynamic one

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

Re: Re: Re: condition not working

aveeeeeee7en — Thu, 03 Jul 2014 09:18:43 GMT

I have applied Tresesco Sir Code. It is working.

Re: condition not working

Thu, 03 Jul 2014 09:24:57 GMT

Is this what you want?

Re: Re: condition not working

vipin_mishra479 — Thu, 03 Jul 2014 09:24:57 GMT

Hi Nag ,

is it ok for me also

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

Re: Re: condition not working

vipin_mishra479 — Thu, 03 Jul 2014 09:28:02 GMT

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

Re: Re: Re: condition not working

Thu, 03 Jul 2014 09:30:30 GMT

I think this is your requirement. You write an expression as =Month. Hide the legend of dimension and check the following properties

Re: Re: Re: condition not working

tresB — Thu, 03 Jul 2014 09:34:25 GMT

Good work around Deepak!

Re: Re: Re: condition not working

Thu, 03 Jul 2014 09:35:18 GMT

PFA the solution.

Re: Re: Re: condition not working

Thu, 03 Jul 2014 09:37:34 GMT

Thanks tresesco

Re: condition not working

aveeeeeee7en — Thu, 03 Jul 2014 09:37:53 GMT

Good Job Deepak.

Very Innovative.

Re: condition not working

Thu, 03 Jul 2014 09:38:51 GMT

Thanks Nag Aviral

Re: Re: condition not working

vipin_mishra479 — Thu, 03 Jul 2014 09:40:44 GMT

Thanks Deepak is it work