topic Re: Set Analysis Help UsingText Box in QlikView

Set Analysis Help UsingText Box

wonkymeister — Tue, 09 Jun 2015 10:08:38 GMT

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,

Phil.

Re: Set Analysis Help UsingText Box

awhitfield — Tue, 09 Jun 2015 11:05:44 GMT

Hi there,

can you upload an example qvw?

Andy

Re: Set Analysis Help UsingText Box

Tue, 09 Jun 2015 11:17:40 GMT

Hi Phil,

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

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

in the background colour of text box for KPI 1 etc

Hope that helps

Joe

Re: Set Analysis Help UsingText Box

Anonymous — Tue, 09 Jun 2015 11:32:23 GMT

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

Re: Set Analysis Help UsingText Box

wonkymeister — Tue, 09 Jun 2015 11:57:26 GMT

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!