topic Two definitions on a bar chart in QlikView

Two definitions on a bar chart

Tue, 14 Aug 2012 09:37:05 GMT

Hi All,

I need help wiriting an expression for a bar chart definition.

I have manged to create a single definition as below, but really struggling to add another selection as I put it.

Currently which works fine

Sum({ <[POH] = {P}>} [Hours])

In english = Sum hours when POH = P

Going forward

Sum({ <[POH] = {P}>} and {<[SITE] = {A}>} [Hours])

In english = Sum hours when POH = P and SITE = A.

Help would be very much appricaited.

rajni_batra — Tue, 14 Aug 2012 09:42:26 GMT

Try This,

Sum({ <[POH] = {P},[SITE] = {A}>} [Hours])

Hope to Help

Tue, 14 Aug 2012 09:43:20 GMT

Sum({ <[POH] = {P},[SITE] = {A}>} [Hours])

Tue, 14 Aug 2012 09:46:21 GMT

Thank you both, I was so close as well.......

Sum({ <[POH] = {P}>} {<[SITE] = {A}>} [Hours]) .