topic Re: Different Color for a Particular value of a dimension in QlikView

Different Color for a Particular value of a dimension

alkesh_sharma — Thu, 18 Sep 2014 07:30:59 GMT

Hyi,

I have created age buckets in the front end based on the basis of due date.

The buckets are like Not Due, 0-30, 30-60, 60-90, etc.

I have used calculated dimension in the bar chart and Sum of invoice value as the expression.

Please find the snapshot of the chart attached.

I want the No-Due bar should have a different color from rest of the bucket bars. for example No dues bars should be of blue color rest to be of Red.

Kindly Help.

Re: Different Color for a Particular value of a dimension

PrashantSangle — Thu, 18 Sep 2014 07:40:42 GMT

Hi,

Try like this,

Go to property->Axes->uncheck->multicolored->

then select 1st color from Data Apeareance->color 1-6->You get new Window Color Area

in that Base Color->select Calculated Color

In that write Expression like

if(CalculatedDimensionExpression='No Due',Blue(),Red())

Regards

Re: Different Color for a Particular value of a dimension

Thu, 18 Sep 2014 07:51:32 GMT

Expand the Expression (Presumably Sum of Invoice that your using) and access the 'Background Colour' property.

Use and IF condition with the calculation that you use for identifying 'No Dues'. In the True part, enter Blue() and else would be Red()

IF(Sum([Your expression for 'No Dues'],Red())

This should work.

Regards,

Re: Different Color for a Particular value of a dimension

Colin-Albert — Thu, 18 Sep 2014 07:56:13 GMT

Click on the [+] next to your expression and you can access additional properties such as Background Color, Text Color, Text Format etc.

Add an 'if' expression to the background colour to change the colour.

Re: Different Color for a Particular value of a dimension

alkesh_sharma — Thu, 18 Sep 2014 08:25:36 GMT

Tried the steps, not working out..

My calculated dimension expression is

=if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) < 0 , Dual('Not Due',1),
	if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 0 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=30, Dual('0-30',2),
		if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 31 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=60, Dual('30-60',3),
			if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 61 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=90, Dual('60-90',4),
				if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 91 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=120, Dual('90-120',5),
					if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 121 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=150, Dual('120-150',6),
						if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 151 AND today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) <=180, Dual('150-180',7),
							if(today()- (if(vPaymentTerms = 1, [Due Date],	Date([Invoice Date] + vPaymentDays,'DD-MM-YYYY'))) >= 181 , Dual('180+',8)))))))))

Re: Different Color for a Particular value of a dimension

alkesh_sharma — Thu, 18 Sep 2014 08:28:16 GMT

The expression is not getting properly copied here.

Please copy and paste it in notepad to vie it clearly.

Re: Different Color for a Particular value of a dimension

Thu, 18 Sep 2014 09:31:42 GMT

Click on the [+] before each of your expressions and add to the Background Color

if([Age Buckets by Due Date]='No Due',Blue(),Red())

Re: Different Color for a Particular value of a dimension

alkesh_sharma — Fri, 19 Sep 2014 05:08:32 GMT

Expanding the expression and adding color expression is not working guys.

Please help...

Re: Different Color for a Particular value of a dimension

Fri, 19 Sep 2014 05:32:01 GMT

hi Alkesh,

I think "if([Age Buckets by Due Date]='Not Due',Blue(),Red())" Should work.

you have written 'No Due' where as it should be 'Not Due'.

Re: Different Color for a Particular value of a dimension

alkesh_sharma — Tue, 23 Sep 2014 06:13:41 GMT

Hey Kuntal, Its 'Not Due' cross checked it twice.

If I do this when the buckets are created in the backed, it works fine, But not working when buckets are created through Calculated dimension in the front end.

Can you do it and gimme the QVW, I am missing something I guess. ???

Re: Different Color for a Particular value of a dimension

Sun, 08 Feb 2015 08:16:49 GMT

Hi Alkesh,

as already mentioned before, use expressions' background color and enter the following expression:

=IF(sum("Your expression DUE") < 0, red())

Important is to use an aggregation. Without aggregation it doesn't work.