Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Find Count of Rows

Hello all,  I want expression to compare value of column A with average of column B and then display one bar where value in A is greater than average of B and another bar where value in A is less than the average of B.

2 Replies

Re: Find Count of Rows

I am not sure how your post title relates to the content withing your post? What exactly are you look for?

jolivares
Valued Contributor

Re: Find Count of Rows

Maybe check some videos in youtube...

Capture.PNG

Expresion:

Sum(Sales)

Avg(TOTAL Aggr( Sum( Cantidad),Year))

If(Sum(Sales)>Avg(TOTAL Aggr( Sum( Cantidad),Year)), Image1,Image2)