Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Two definitions on a bar chart

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.

1 Solution

Accepted Solutions
Not applicable

Re: Two definitions on a bar chart

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

3 Replies
rajni_batra
Valued Contributor

Re: Two definitions on a bar chart

Try This,

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

Hope to Help

Not applicable

Re: Two definitions on a bar chart

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

Not applicable

Re: Two definitions on a bar chart

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

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

Many thanks rajni.batra and Simon Ijäs

Community Browser