topic Re: Help with Dynamic Colors/Text Box in QlikView

Help with Dynamic Colors/Text Box

Mon, 16 Mar 2015 22:14:51 GMT

So I have the following expression.

=num(sum({$<skill_type_id = {1},question_is_active = {1},answer_score = {0,1},topic_id = {6}>}answer_score)

/(count({$<skill_type_id = {1}, question_is_active = {1}, topic_id = {6}>}answer_id)-

count({$<skill_type_id = {1},topic_id ={6}, question_is_active = {1},answer_score = {'-1'}>}answer_score))

*100

,'##.#')&'%'

I want to the active text to be colored red when the number is <30,

30 < Black < 60,

> 60 Green

I'm having alot of trouble syntax wise getting the coloring to work. I've tried turning the above expression into a variable. Getting rid of the percentage change etc. but no luck.

Any thoughts?

Thanks!

Re: Help with Dynamic Colors/Text Box

fred_s — Mon, 16 Mar 2015 22:28:32 GMT

Hi Patrick,

1. Add a label to your expression

2. Click on the Plus sign at the left

3. Click on Text Color

If (Labelname < 30, red(), black())

Grtz. Fred

Re: Help with Dynamic Colors/Text Box

maxgro — Mon, 16 Mar 2015 22:59:41 GMT

if (label < 30, red(),

if (label < 60, black(),

green() ))

Re: Help with Dynamic Colors/Text Box

Tue, 17 Mar 2015 15:05:01 GMT

Thanks it was that simple

Re: Help with Dynamic Colors/Text Box

fred_s — Tue, 17 Mar 2015 18:59:13 GMT

Hi Patrick,

If your question is answered, please mark it as answered.

Means also that people who are trying to help others,

don't have to put energy in this thread any more 😉

Thanks