topic Re: Expressions in charts! in QlikView

Expressions in charts!

Thu, 16 Apr 2015 15:10:20 GMT

=Avg({<[E_D Code]={'10'},[E_D Code]={'45'} >}Amount)

The above is only showing me for EDCode 45 and not EDCode 10. How do I display both?

buzzy996 — Thu, 16 Apr 2015 15:15:38 GMT

use this,

=Avg({<[E_D Code]={'10','45'} >}Amount)

Thu, 16 Apr 2015 15:17:57 GMT

Avg({<[E_D Code]={'10','45'} >}Amount)

should work.

basically

[E_D Code]={'10','45'} in set Analysis is OR condition.

buzzy996 — Thu, 16 Apr 2015 15:20:50 GMT

can u mark as correct if ur happy with tht sol