topic Re: Plot colors based on combinations in QlikView

Plot colors based on combinations

sureshbaabu — Fri, 07 Mar 2014 07:57:42 GMT

Hello,

I have requirement to plot colors on chart view based on its presence on category.

Data Set:

In the Data set above:

Group A has presence in India on both Cricket and FB - so I wanted to show it presence in Green

Group A has presence in AUS only on FB - so I wanted to show it presence in Yellow

Group A has presence in SA only on Cricket - so I wanted to show it presence in Blue

Group A dosnt have any data for ENG - so I wanted to show it as RED

I have attached the expected output for more clarity on the requirement .

Please share your thoughts on the request above.

Thanks,

Suresh

Fri, 07 Mar 2014 08:06:48 GMT

You need to put in a background colour in the expression.

Expand out and place the IF statement within the background - you will need to use RBG(0,0,0) etc to get the colour to display.

IF(count{<Group={'A'},Country={'India'},Category={'Cricket','FB'}>}Group)>=1,Green())

Fri, 07 Mar 2014 08:28:38 GMT

You need to put in a background colour in the expression.

Expand out and place the IF statement within the background - you will need to use RBG(0,0,0) etc to get the colour to display.

IF(count{<Group={'A'},Country={'India'},Category={'Cricket','FB'}>}Group)>=1,Green())

whiteline — Fri, 07 Mar 2014 11:17:23 GMT

Hi.

It's easy. You colors is connected with data with complex key Country|Category.

Create this field in your fact table and load corresponding table with colors.

sudeepkm — Fri, 07 Mar 2014 13:13:50 GMT

Is this something you are looking for?

sudeepkm — Fri, 07 Mar 2014 13:22:13 GMT

Please use the attached one.

sureshbaabu — Fri, 07 Mar 2014 14:37:12 GMT

Hi Sudeep,

Yeah, that's a great solution!!!

This will help to fix my issue. Thank you