Qlik Community

Community Corner

Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mikael_cleuziou
Partner
Partner

RGB and SET ANALYSIS

Hello,

I have a problem with a set analysis in a RGB function.

I have joined an example.

1) I have amounts by City, Region, Country

2) I have an apple pie with a drill functionnality

3) I have a chart with a set analysis on ALL Region from France

4) I have a RGB function to define Regions colors.

My problem : When I choose in my apple pie one region in France, I keep all my regions bars but I loose two colors.

My solution (doesn't works...) : RGB({1}REGIONR,REGIONG,REGIONB) or RGB({1}REGIONR,{1}REGIONG,{1}REGIONB)

I don't know how to do a set analysis with a RGB!

Thanks for your help...

Mika

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

only({1}RGB(REGIONR,REGIONG,REGIONB))

as background color attribute expression. Set expression only works with aggregation functions like sum(), only() ...

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

only({1}RGB(REGIONR,REGIONG,REGIONB))

as background color attribute expression. Set expression only works with aggregation functions like sum(), only() ...

mikael_cleuziou
Partner
Partner
Author

Many thanks, 15 526=> It was me.