Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mikael_cleuziou
Partner - Contributor III
Partner - Contributor III

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 - Contributor III
Partner - Contributor III
Author

Many thanks, 15 526=> It was me.