Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

3 Replies
rajni_batra
Specialist
Specialist

Try This,

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

Hope to Help

Not applicable
Author

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

Not applicable
Author

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

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

Many thanks rajni.batra and Simon Ijäs