topic Using the Calculus value to choose color in QlikView

Using the Calculus value to choose color

Mon, 13 Sep 2010 16:24:01 GMT

HI,

Does anybody knows how to use an object calculus results to set the color? Something similar to using the pivot table expression name into another expression.

For Example:

A TextBox has the formula : =sum(VALUE)

At the Back Color, I have chosen the calculated color and set: if( sum(VALUE) >20, RED(), WHITE())

Is there a way I could use the textbox´s formula directly into the color formula. It would become something like:

if( TEXTBOX.FORMULA >20, RED(), WHITE())

This would help a lot the maintenance of the code as if I make changes to the text formula, it would automatically change the same value for the color.

Cheers

Adriano

Using the Calculus value to choose color

willinek — Mon, 13 Sep 2010 20:52:03 GMT

Hi Adriano,

why don't you use variables. you could store your expression into a variable and úse this one instead of a textbox. Of course you can display the variable in a textbox, too. But maybe my Idea is a little bit to simple

Alex

Using the Calculus value to choose color

Mon, 13 Sep 2010 23:08:27 GMT

yeap,

I thought of that. But sometimes managing 20 variables is kind of messy. If it uses the same formula inside the textbox, I would manage them individually.

Thanks for the suggestion any way.

Adriano