topic Re: Color-Coding by Assigned Groups in QlikView

Color-Coding by Assigned Groups

Wed, 08 Oct 2014 23:23:43 GMT

Hello,

Thanks in advance for taking this question.

Basically, I have several different market areas which I would like to color code by (placing them into regions). See the screenshot attached.

I want to group these individual markets into say 4 Groups: East, West, North, South and color-code them.

For example, I would like to put NY Metro and Northeast into the "East" Group, and make it Red,
San Jose and So. Co into the "West" Group and make it Blue,
Florida and Carolinas into the "South" Group and make it Pink
and so on

Can someone please let me know what I have to do to
a) Create these groups
b) What the expression needs to be to color code these
c) Where I write the expression/and create these groups

I REALLY appreciate it!

Ryan

Re: Color-Coding by Assigned Groups

ashwanin — Thu, 09 Oct 2014 04:38:33 GMT

Hi Ryan,

Please attach some sample data and what you required from that.

Re: Color-Coding by Assigned Groups

Thu, 09 Oct 2014 05:03:12 GMT

Dear Ryan,

You just need to do it into script.

Simply make a field with name group like:-

if(field=NY Metro or field=Northeast,'East',

if(field=San Jose or field=So. Co,'West',

if(field=Florida or field=Carolinas,'South',field) as group

Thanks & Regard

Prince Anand

Re: Color-Coding by Assigned Groups

PrashantSangle — Thu, 09 Oct 2014 05:03:15 GMT

Hi,

Select Dimension->click On + sign->Text Color->

Write expression like,

If(wildmatch(dimensionName,'NY Metro','Northeast'),Red(),

if(wildmatch(dimensionName,'San Jose','Northeast'),Green()))

Regards

Re: Color-Coding by Assigned Groups

raptibhowal — Thu, 09 Oct 2014 05:17:03 GMT

Hi Sir,

If there are many data, like there could 10 places in northeast. Then we have to 10 times, is thr any alternative to make it dynamic.

Like the issue mention in the image.