Selections not excluded in set expression

udaya_kumar — Thu, 31 Jan 2013 06:05:51 GMT

Hi,

I am using the below set expression in the line chart,

=if((Sum({<Product_Id={9},timeframe=, agg_period=>}Volume))>$(vPlus),RGB(0,255,0),

if((Sum({<Product_Id={9},timeframe=, agg_aeriod=>}Volume))<$(vMinus),RGB(255,0,0),RGB(0,0,0)))

I am using this expression in Background color for Volume Expression. So if the volume is greater than vPlus value, then it will show those dots as green color in the chart.

But the Timeframe and Agg_Period fields are not getting excluded in the expression, if we select these two field values in a listbox, then the green color is changing to normal line color.

why it is happening like this?

Re: Selections not excluded in set expression

swuehl — Thu, 31 Jan 2013 09:28:07 GMT

Have you double checked the exact spelling of your field names in the set expression (your sample expression differs from you stated as field names)? Field names are case sensitive and you need to put in field names only, no labels etc.

Then, what is the definition of vPlus resp. vMinus variable?

It would probably make things easier if you could upload a small sample file that demonstrate your issue.

topic Re: Selections not excluded in set expression in QlikView

Selections not excluded in set expression

Re: Selections not excluded in set expression