topic Alert Generation in QlikView

Alert Generation

rajtechnocraft — Mon, 18 Oct 2010 06:59:08 GMT

Hi Guys,

I am using the following formula for alert generation.

if(Aggr((Sum(Sales)<=100), Country),Sum(Sales),0)

But i get the value in MSG box always 0

Please help i want to display only those values whose sale value is less than or equal to 100

Thanks

Alert Generation

Mon, 18 Oct 2010 11:40:27 GMT

Where are you using that formula? Without describing the problem, nobody can help you 😉

However, are you really sure you need the "aggr" keyword? If you are using the formula outside of a chart expression, why you should pre-aggregate by Country?

If you are trying to make Country a dimension of your chart, but want to filter out values "with low sales", so to speak, you could use set analysis in your chart expressions or even your chart dimension:

=Only({<Country = {"=(Sum(Sales) >= 100)"} >} Country)

I just typed this here, so I didn't checked it, but it should work. The idea is to show the Country ONLY where the sum of sales is greater or equal to 100.

Hope it helps.

Bye!

Alert Generation

Mon, 18 Oct 2010 11:49:45 GMT

Adding some notes: if you want to work on the chart dimension, you should use Aggr(Only(... Country), Country).

If you want to work on the expressions, just copy and paste the Set part beetween {}.

Bye