straight table background color expression

Thu, 28 May 2009 16:30:13 GMT

Hi all,

Using Oleg's color document (good stuff) I can set the color of cell backgrounds but I need to set an expression instead (eg '=fieldvalue('Repair', 1) ') so that it is set at calculation time.

The example in the API guide that seemed like it should work doesnt (8.20) although the macro interpretor doesnt complain about the code:

set Graph = ActiveDocument.Sheets("Main").CreateBarChart

Graph.AddDimension "ProductType"

Graph.AddExpression "sum(Amount)"

Graph.AddBkgColorExpression "if(sum(Amount)>10,green(),red())",0

Any help appreciated.

Regards,

Gordon

straight table background color expression

Anonymous — Mon, 13 Jul 2009 21:24:51 GMT

Have the same problem in Qlikview 9 with scatter plot

set chart=ActiveDocument.GetSheetObject("CH.volcano")
chart.RemoveExpression 1
chart.RemoveExpression 0
chart.AddExpression baseN& ".coef"
chart.AddExpression baseN& ".pval"
chart.AddBkgColorExpression "ColorMix1(xRDbefore080615.DEF.Ave/Max(TOTAL xRDbefore080615.DEF.Ave),white(),red())",0

the above code modifies a existing chart except changing point color. it adds the ColrMix.. expression as a new property of the first expression instead of adding it into the "Background Color" definition slot. Add the expression into "Background Color" definition slot manually works as supposed

Vlad

topic straight table background color expression in QlikView

straight table background color expression

straight table background color expression