Discussion board where members can get started with QlikView.
In a pivot table with date as dimension and a bunch of metrics as colums, i wat a background color for the first expression which is
the expression for determining the bacground color is derived from 2 fields, a mean and a standard deviation
the expn fr the bg color is :
but no matter what numbers i put for 'msearch_estimate' and 'msearch_std' , it shows only the first color.
Why? wat is wrong with this expn ????
>> and << are bit shift operators not comparison operators. Try something like
If(Sum(mini_msearch) < (msearch_estimate-msearch_std),RGB(255,142,77),
if(Sum(mini_msearch) > (msearch_estimate+msearch_std),RGB(160,184,231)
View solution in original post