topic Re: How to handle color dynamically? in QlikView

How to handle color dynamically?

durgabhavani — Mon, 28 Nov 2016 12:06:46 GMT

Hi All,

Please help me to handle color dynamically.

I have customer code in my application and assigned one color to each customer code. Now problem is whenever new customer with new customer code come on to my dashboard, I need to assign one new color dynamically to that customer without my intervention.

how to handle. Please advice

Please find the attached sample application.

Thanks,

Durga

Re: How to handle color dynamically?

tresB — Mon, 28 Nov 2016 12:38:56 GMT

May be something like:

Pick(Match([Customer Code], 'SA1', 'SA2', 'SA3', 'SA4','SA5')+1,Color(RowNo(total)),$(v_color_CC1),$(v_color_CC2),$(v_color_CC3),$(v_color_CC4),$(v_color_CC5))

Re: How to handle color dynamically?

durgabhavani — Tue, 29 Nov 2016 06:36:41 GMT

Hi Tresesco,

Thanks for reply.

I am bit confused to implement in my app. Can you please apply in my application?

Thanks,

Durga

Re: How to handle color dynamically?

shraddha_g — Tue, 29 Nov 2016 06:42:04 GMT

Create a Excel with Customer Code and Associated RGB Code.

Link this source in Data model with Customer Code and user RGB Code field in Expression for color

Re: How to handle color dynamically?

durgabhavani — Tue, 29 Nov 2016 07:05:17 GMT

Hi Shraddha,

I have created variables and user RGB for existing customer codes and successfully displaying on dashboard. But problem is with when one new customer code comes to dashboard, how to add new color dynamically?

please advice.

Thanks,

Durga