Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Background color for an expression

Hi,

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

sum(search)

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 :

If(Sum(mini_msearch)<<msearch_estimate-msearch_std,RGB(255,142,77),if(Sum(mini_msearch)>>(msearch_estimate+msearch_std),RGB(160,184,231)))

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 ????

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Background color for an expression

>> 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

1 Reply
Highlighted
MVP
MVP

Re: Background color for an expression

>> 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