topic Please help with one script in QlikView

Please help with one script

Thu, 09 Feb 2012 00:12:54 GMT

I been trying to show on a graphic the count of a certain information.

Example:

I put if (avg(WIN)*1.20>=avg(WIN), count (MANUFACTURE),)

The result always will be 5 (the count if MANUFACTURA rows).

What I need is that only count the amount of manufactures that are above the average by 20%.

On the Example the average will be 102.2 and the total manufactures above average will be 2.

I think the problem is what i have to put instead of count (MANUFACTURE).

Hope you can help me.

REGARDS

Thu, 09 Feb 2012 03:34:16 GMT

Hi Carlos,

You could do this:

COUNT(IF(WIN >= AVG(TOTAL WIN) * 1.2, MANUFACTURE))

Thu, 09 Feb 2012 04:23:57 GMT

Use expression as below:

=count({1<WIN ={">=$(vAverage)"}>}MANUFACTURE)

vAverage is a variable with expression =avg({1}WIN)*1.20

CELAMBARASAN — Thu, 09 Feb 2012 04:57:21 GMT

Hi,

Try with this,

=Sum(Aggr(If(Avg(WIN)>=(Avg(TOTAL {1} WIN)*1.20),1,0),MANUFACTURE))

Hope it helps

Celambarasan

Thu, 09 Feb 2012 06:40:54 GMT

Try this

=sum(if(WIN1>$(v),1,0))

=Avg(WIN1)*1.2

Fri, 10 Feb 2012 01:17:07 GMT

Thanks for your help