Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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