topic Re: Creating a guage from text field in QlikView

Creating a guage from text field

Anonymous — Mon, 21 Jul 2014 13:29:54 GMT

I have a field with 5 possible text values -

Far ahead

Ahead

On track

Behind

Far behind

I would like to create a traffic light gauge with a colour for each of the five values e.g. red for 'far behind', green for 'far ahead' etc. How do I do this?

Thanks

Greg

Re: Creating a guage from text field

datanibbler — Mon, 21 Jul 2014 13:44:15 GMT

Hi Greg,

I assume that field is the result of a calculation?

Just create a traffic light gauge and assign five segments to it - untick the checkboxes at the bottom, then you can assign a starting_value for each segment. They need not necessarily be equally distributed, but since you have five values, that seems the easiest.

The only problem is, you cannot assign text_values to those segments, so you need to map them with numeric values - you can do that via a mapping table and the ApplyMap() command.

Re: Creating a guage from text field

ashfaq_haseeb — Mon, 21 Jul 2014 13:45:33 GMT

Hi,

May be like this.

Regards

ASHFAQ

Re: Creating a guage from text field

Anonymous — Mon, 21 Jul 2014 13:51:44 GMT

Thanks for your response.

The field is the result of management judgement rather than a calculation.

I am not familiar with mapping tables or the ApplyMap() command. Would you be willing to supply an example?

Thanks

Greg

Re: Creating a guage from text field

jerem1234 — Mon, 21 Jul 2014 13:55:19 GMT

You can always use pick(match()). Then just use different segments for what you want. For example:

pick(match(FIELD, 'Far ahead', 'Ahead', 'On track', 'Behind', 'Far behind'), 5, 4, 3, 2, 1)

Hope this helps!

Re: Creating a guage from text field

ashfaq_haseeb — Mon, 21 Jul 2014 14:05:32 GMT

Hi,

Have you look at my application.

Regards

ASHFAQ

Re: Creating a guage from text field

Anonymous — Mon, 21 Jul 2014 14:29:58 GMT

Thanks. How would I apply your expression to work out a traffic light value for each of the areas in the following data:

Greg

Re: Creating a guage from text field

Mon, 21 Jul 2014 19:20:49 GMT

YOU MEAN THIS?

You can always use pick(match()). Then just use different segments for what you want. For example:

pick(match(FIELD, 'Far ahead', 'Ahead', 'On track', 'Behind', 'Far behind'), 5, 4, 3, 2, 1)

Hope this helps!

Re: Creating a guage from text field

Anonymous — Tue, 22 Jul 2014 10:55:07 GMT

OK. So this applies a numeric value to the FIELD values and I can now get the gauge to work nicely. Thanks!

How do I introduce another field into the expression? e.g.

pick(match(([$<OTHERFIELD={'x'}>} FIELD, 'Far ahead', 'Ahead', 'On track', 'Behind', 'Far behind'), 5, 4, 3, 2, 1))

But this doesn't work.

Thanks

Greg

Re: Creating a guage from text field

jerem1234 — Tue, 22 Jul 2014 14:58:58 GMT

Match does not allow for set analysis.

You can try using the only function inside:

pick(match(only({<FIELD2 = {'x'}>}FIELD), 'Far ahead', 'Ahead', 'On track', 'Behind', 'Far behind'), 5, 4, 3, 2, 1)

Hope this helps!

Re: Creating a guage from text field

Anonymous — Tue, 22 Jul 2014 15:05:47 GMT

Thanks Jeremiah