topic Background colur for dimension & expression in the chart in QlikView

Background colur for dimension & expression in the chart

Tue, 13 Mar 2012 20:59:57 GMT

Hi Folks,

I need to change the background colur for the dimensions & expressions in the chart. This is my senerio.

I have one List box (Main Listbox - ID), Multi box (ID Type, SUB_ID_Value) & Pivot chart (columns associated with ID and each column shold be associated with one or more columns).

Suppose I click on the value in the ID list box, the values highlighted in the mutibox & pivot table. But I need to change the back ground colur of the dimensions & expressions if not associated with ID value and ID Type.

I need to catch the value of the ID Type to change the background colur.

Please help how to catch the ID Type value of the ID value when I click om the ID List box value. (Note: I didn't select any value in the ID Type)

Thanks & Regards,

Siri

Re: Background colur for dimension & expression in the chart

Tue, 13 Mar 2012 21:14:08 GMT

Hi,

You can write If condition with rgb numbers for the back ground color option in dimension and expression based on your selction condition.Like

if (getselectedcount(IDValue)=1,rgb(255,110,134),rgb(130,132,89))

This is just an example.Color numbers are random.

Background colur for dimension & expression in the chart

Tue, 13 Mar 2012 21:20:35 GMT

Thanks Chaitanya for quick reply.

I need to compare the ID type value in if condition. But where can i get the ID Type value of ID value?

Background colur for dimension & expression in the chart

Tue, 13 Mar 2012 21:25:43 GMT

So list box is ID value and rest of the objects have only ID types?No ID values?

Background colur for dimension & expression in the chart

Tue, 13 Mar 2012 21:31:43 GMT

No. Suppose 1 ID value conatins 3 ID Types and these 3 objects have 3 columns and associated with ID. These 3 c0lumns back ground colur will highlighted in the pivot chart.