topic Re: Dimension Data conditional Format in QlikView

Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 04:51:19 GMT

Hi,

I am trying to change the color of the dimension in a pivot table based on one condition.

Dimension: Period

Value: 2013,2014

Condition:if(2013>2014),Green,Red

Can please let me know

Re: Dimension Data conditional Format

prashantbaste — Tue, 16 Jun 2015 05:25:14 GMT

Hi Sasi,

When you add dimension, you can see , you can click on it and will get some more options as -

Click on 'Background Color' option & write condition as -

If(Period='2013',Green(),If(Period='2014',Red()))

It will show color in background.

Hope this will be helpful for you.

Regards,

Prashant P Baste

Re: Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 05:30:21 GMT

Hi,

Not based on 2013 and 2013, we have one expression and the condition is 2013 Vs 2014

Re: Dimension Data conditional Format

tamilarasu — Tue, 16 Jun 2015 05:32:15 GMT

Hi,

Can you post sample data?

Re: Dimension Data conditional Format

prashantbaste — Tue, 16 Jun 2015 05:41:46 GMT

Then same thing you need to do in expression -

In 'Background Color' of expression, you can write the condition as -

=If((Sum({<Year='2013'>}Amount))>=(Sum({<Year='2014'>}Amount)),Green(),Red())

I hope now I have made right assumptions...!

Is this the solution that you were looking at?

Regards,

Prashant P Baste

Re: Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 07:22:50 GMT

PFA sample QVW

Re: Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 08:48:03 GMT

Can any one help me out..

gwassenaar‌

Re: Dimension Data conditional Format

Gysbert_Wassenaar — Tue, 16 Jun 2015 08:57:00 GMT

Add the conditional color expression to the dimension Background Color setting instead of that of the chart expression.

Re: Dimension Data conditional Format

tamilarasu — Tue, 16 Jun 2015 09:07:33 GMT

Hi Sasi,

Check out the below attachment.

Re: Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 09:18:44 GMT

My requirement is

if value of 2013 is > 2014, then that value should be green, similarly wise versa.

Re: Dimension Data conditional Format

vardhancse — Tue, 16 Jun 2015 10:06:53 GMT

Hi Gysbert,

thanks for your reply, I want the result as below like which ever value in 2012/2013 was higher that color need to be green other should be Red

Re: Dimension Data conditional Format

Gysbert_Wassenaar — Tue, 16 Jun 2015 10:32:55 GMT

See attached example.

Re: Dimension Data conditional Format

vardhancse — Wed, 17 Jun 2015 04:30:56 GMT

Thank you so much Gysbert.

Re: Dimension Data conditional Format

gautik92 — Wed, 17 Jun 2015 06:47:03 GMT

Use this in Expression->Background Color or Text Color

=If((Sum({<Year='2013'>}Amount))>(Sum({<Year='2014'>}Amount)),Green(),Red())

Re: Dimension Data conditional Format

vardhancse — Wed, 17 Jun 2015 06:48:40 GMT

Hi solution provided by gwassenaar‌ was exactly my requirement.

Re: Dimension Data conditional Format

vardhancse — Wed, 17 Jun 2015 09:46:42 GMT

Hi Gysbert,

One more help is that if the value for 2012 and 2013 was blank it should show blank in the YOY, instead it is showing symbol.

can please help me out.

Re: Dimension Data conditional Format

vardhancse — Wed, 17 Jun 2015 09:50:43 GMT

Hi got it, added isnull function for the measure and all blanks were showing -