topic Conditional Based Graphs display in QlikView in QlikView

Conditional Based Graphs display in QlikView

vardhancse — Thu, 24 Oct 2013 15:35:25 GMT

Hi All,

I have a requirement is that, need to display the graphs with different colors based on some conditions like

Take an issue completion percentage graph:

1. For percentage below 100% need to be blue

2. For percentage exactly 100% need to be green

3. For percentage above 100% need to be Red.

Can any one help me out to solving the same.

Thanks & Regards,

Sasi

Re: Conditional Based Graphs display in QlikView

Aurelien_Martinez — Thu, 24 Oct 2013 15:43:05 GMT

Hi,

On chart properties you can change background color of your expression:

On definition you can write:

If(value<1,

Blue(),

If(value=1,

Green(),

Red()

)

Regards

Aurélien

Re: Conditional Based Graphs display in QlikView

vardhancse — Thu, 24 Oct 2013 15:45:36 GMT

Hi Thanks for your quick reply..

Will try now and let you know..

Thanks

Re: Conditional Based Graphs display in QlikView

vardhancse — Thu, 24 Oct 2013 16:01:19 GMT

Hi Aurélien,

As mentioned used the below mentioned condition:

if ([Nov-13]>100, RGB(255,0,0))

But was unable to get the color change for values above 100.

Can you please let me know any other options.

Thanks in advance for your support

Re: Conditional Based Graphs display in QlikView

vikasmahajan — Thu, 24 Oct 2013 16:03:32 GMT

I have also same issue with my chart !

Please post if you got proper solution.

Thanks

Vikas

Re: Conditional Based Graphs display in QlikView

vardhancse — Thu, 24 Oct 2013 16:04:58 GMT

Hi Vikas,

Tried the above mentioned condition, but was unable to get the requirement.

Will let you know once if i found any solution . If you got it please let me know.

Thanks & Regards,

Sasi

Re: Conditional Based Graphs display in QlikView

Aurelien_Martinez — Thu, 24 Oct 2013 16:06:14 GMT

Can you post a application?

if ([Nov-13]>100,

RGB(255,0,0),

if(if ([Nov-13]=100,

RGB(0,255,0),

RGB(0,0,255)

)

Re: Re: Conditional Based Graphs display in QlikView

offjunior — Thu, 24 Oct 2013 20:21:26 GMT

Hello!

Try it:

Re: Re: Conditional Based Graphs display in QlikView

vardhancse — Sun, 27 Oct 2013 14:33:30 GMT

Hi,

Tried the same. But was able to get only 2 conditions based color.

Thanks & Regards,

Sasi

Re: Re: Conditional Based Graphs display in QlikView

offjunior — Mon, 28 Oct 2013 01:24:25 GMT

Good night!

If the solution that you've is correct, let others know that, to use the same solution, marking my answer as correct.

Thank you!

Re: Conditional Based Graphs display in QlikView

jagan — Mon, 28 Oct 2013 02:41:38 GMT

Hi Sasi,

Can you attach sample file?

Regards,

Jagan.

Re: Re: Conditional Based Graphs display in QlikView

vardhancse — Wed, 30 Oct 2013 07:00:25 GMT

Hi,

out of 3 conditions only 2 conditions were getting displayed. Can you please check it once.

Thanks & Regards,

Sasi

Re: Re: Conditional Based Graphs display in QlikView

offjunior — Wed, 30 Oct 2013 10:47:47 GMT

Good morning!

In the file I sent you, all three conditions are displayed. When the salary is less than 4000 color is blue, when the salary is equal to 4000 and the color is green when the salary is greater than 4000 color is red. Note that all the colors are in the chart. If it is something else you want, please modify my application and sent me so I can check.

Hug!