Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshbaabu
Creator III
Creator III

Plot colors based on combinations


Hello,

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

Data Set:

GroupCountry Categoryno_of_players
AIndiaCircket2
AIndiaFB7
AAusFB2
ASACircket6
AEng
BIndiaCircket5
BAusFB8
BSAFB1
BEng Circket5

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

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

Please use the attached one.

View solution in original post

6 Replies
Not applicable

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())

Not applicable

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
Master II
Master II

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
Specialist III
Specialist III

Is this something you are looking for?

sudeepkm
Specialist III
Specialist III

Please use the attached one.

View solution in original post

sureshbaabu
Creator III
Creator III
Author

Hi Sudeep,

Yeah, that's a great solution!!!

This will help to fix my issue. Thank you