topic Re: Column() function in calculated color expression in QlikView

Column() function in calculated color expression

azimabadi — Tue, 26 Feb 2013 16:03:21 GMT

Hi all,

i have a simple gauge chart, it's a colored square that i need to decide the color based on the value of expression.

But i don't want to use the same expression in calculated color expression, becuse in my project it's really long and i need to repeat it many times, so i use the column() function.

(you can see the configuration in pics or check the qvw file.)

But it looks like that Column function dosn't work here.

I will appreciate any idea.

Best Regards - Peyman

Re: Column() function in calculated color expression

Anonymous — Tue, 26 Feb 2013 18:27:13 GMT

If you don't want to copy the full expression of the column 1, you can create a variable, and define it as the text of your expression. Do not use "=" in variable definition, it will return the result rather than expression text. Use this variable in color expression.

Regards,

Michael

Re: Column() function in calculated color expression

azimabadi — Tue, 26 Feb 2013 20:12:08 GMT

Thank you Michael for answer,

but i have about 100 so squares and this means that i need to defiene 100 another variables for colors.

But when i can use Column function that means i need to defein the color variable only one time.

Best Regards - Peyman

Re: Column() function in calculated color expression

Anonymous — Wed, 27 Feb 2013 14:16:34 GMT

Peyman,

I'm not sure what you're trying to do, sorry. I was going to ask how come you have multiple expressions for one column - but there is no "column" in gauge charts. It is relevant for staright or pivot tables. Your attached example is not very helpful either. The only I can see that you're expecting to refer to a table box from the gauge chart, and it doesn't work this way. The color is red if you use expression sum(a) for color.

Probably you have to use expressions as is, no matter how complex they are. Variables for expressions (or parts of expressions) will be helpful, I think.

Regards,

Michael

Re: Column() function in calculated color expression

azimabadi — Thu, 28 Feb 2013 08:09:45 GMT

Thx Michael,

the idea is to build a management dashboard with many squares that each shows a KPI. The following picture can be helpful to catch the main principle.

(picture: StockTouch ios app.)

and user can get more information with clicking on every square.

At the moment i have to repeat the expression for color calculation process, as you mentioned.

I thought it can be better if i can find any approach that allows me to use the calculated value of KPI, as we use the column function in pivot and straight tables.

You know it's a grate performance hack and can reduce the total calculation time of chart. Also it makes the development process easier because i don't have to repeat the big expression that calculate some 7 or 11 shades of colors for every KPI.

You are completely right about using vars and it's what makes me suffer less to produce this nice dashboard!

Best Regards - Peyman

Re: Column() function in calculated color expression

Thu, 28 Feb 2013 09:17:24 GMT

May I ask why you are using a gauge chart? I guess it will be more simple to get the colors right if you would use a straight table (chart), and dynamically change the background color of the expression. This way, you can label the expression and use this label in the calculation for the background color.

Re: Column() function in calculated color expression

azimabadi — Thu, 28 Feb 2013 10:11:08 GMT

as i said, i need to demonstrate many KPIs and every KPI is defined as a formula. with this structure I cant use a table to show the results. That means for every box i have a different expression.