set analysis query, with if statements. help needed!

Mon, 06 Jul 2009 15:31:09 GMT

Hi everyone,

I have a background colour expression:

if( RAGRating = 'Red',rgb(255,0,0),

(RAGRating ='Amber',rgb(255,128,0),

rgb

(51,204,102)

I would like to put a set analysis variable in it but am facing problems. my variabvle is $(vTask) which includes the set analysis. Can anyone think of a way in which I can implement this? I tried

=if( $(vTask) RAGRating = 'Red',rgb(255,0,0),

($(vTask) RAGRating ='Amber',rgb(255,128,0),

rgb(51,204,102)

Thanks in advance.

set analysis query, with if statements. help needed!

stephencredmond — Mon, 06 Jul 2009 16:45:10 GMT

Hi,

Sets need to have a function to reside in (like Sum, Avg, Count, Min, Max, etc.) whereas you have a static IF statement with static values.

If the RAGRating value is a field, I might look at something like:

=if( MaxString ($(vTask) RAGRating) = 'Red',rgb(255,0,0), ...

Stephen

topic set analysis query, with if statements. help needed! in QlikView

set analysis query, with if statements. help needed!

set analysis query, with if statements. help needed!