Set Analysis Help UsingText Box

[wonkymeister]

I have a table of data loaded into my app as thus:

KPI Number	KPI Description	Background Colour
1	UK Sales	Red (could pass RGB values instead?)
2	Overseas Sales	Amber
3	Surplus	Green
4	Staff Costs	Amber

I would like to have a series of text boxes on my dashboard, with each one representing a KPI Number

i.e Text Box 1 is KPI 1, Text Box 2 is KPI 2 etc, and the background colour of each text box relates to the Colour column of the table of loaded data (so the background colour of Text Box 1 would be Red)

what I can’t work out is how to assign each text box as a fixed KPI. If I could assign a KPI Number to a Text Box then I can pass the assigned colour from the table as the background colour.

Any ideas anyone?

Thanks in advance,

1. Phil.

[awhitfield]

Hi there,

can you upload an example qvw?

Andy

[#3 · Accepted solution]

Hi Phil,

I would use the RGB you need for each and then use set analysis to code each text box as you require.

So

$(=Only({<[KPI Number]={1}>}[Background Colour]))

in the background colour of text box for KPI 1 etc

Hope that helps

Joe

[Anonymous]

Hi Phil,

I know this is a bit rough around the edges but I've made an example of how you can do it. The colours are defined as RGB() in the variables and are selected by using the same set analysis code used to get the text in the boxes. This would allow the dashboard to be changed via changes in the data.

Regards,

Geoff

[wonkymeister]

both work a treat!!! - thanks a MILLION

i couldn't work out how to pass a colour using an aggregation function - works brilliantly and ties off the last bit of work on the app

thanks again!