Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help with one script

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

Example:

WINMANUFACTURE
100PRO A
78PRO B
125PRO C
183PRO B
25PRO C

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Carlos,

You could do this:

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

View solution in original post

5 Replies
Not applicable
Author

Hi Carlos,

You could do this:

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

Not applicable
Author

Use expression as below:


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

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this,

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

Hope it helps

Celambarasan

Not applicable
Author

Try this

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

=Avg(WIN1)*1.2

Not applicable
Author

Thanks for your help