topic Color Function in QlikView

Color Function

MK_QSL — Sat, 28 Sep 2013 08:33:08 GMT

I found below code from of the Community Question...

Can someone explain how below function work?

=if(GetSelectedCount(Product) and SubStringCount(Concat(distinct Product),Product),color(FieldIndex('Product',Product)))

jagan — Sat, 28 Sep 2013 11:31:48 GMT

Hi Manish,

=if(GetSelectedCount(Product) and SubStringCount(Concat(distinct Product),Product),color(FieldIndex('Product',Product)))

GetSelectedCount(Product) - Checks whether any product is selected in listbox

Concat(Distinct Product) - Concats all the selected values in Product listbox

SubStringCount(Concat(Distinct Product, Product) - Checks whether the product is exists in the concatenated string (output of Concat())

FieldIndex('Product',Product) - Will give the index number of the Product in the Product dimension

Color(FieldIndex('Product',Product)) - Will give the color code (RGB()) for the index number of the product value.

Finally, this expression is used to assign the Color to the Product in chart.

Hope this helps you.

Regards,

jagan.

MK_QSL — Sat, 28 Sep 2013 11:58:01 GMT

Thanks Jagan

Anonymous — Sat, 28 Sep 2013 17:29:50 GMT

Great explanation !

I wish manuals written this way. But it's just a dream.

Thanks.