Discussion Board for collaboration related to QlikView App Development.
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.
I am not sure how your post title relates to the content withing your post? What exactly are you look for?
Maybe check some videos in youtube...
Expresion:
Sum(Sales)
Avg(TOTAL Aggr( Sum( Cantidad),Year))
If(Sum(Sales)>Avg(TOTAL Aggr( Sum( Cantidad),Year)), Image1,Image2)