Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Conditions in Expression

Hi,

I have the following expression : -

sum({$<status={'Closed'}>} Duration/60)

which is basically : Sum(Duration/60) Where Status = "Closed"

What I want is

Sum(Duration/60) where status = "Closed" AND Product_Type=" Software" or "Hardware" or "Training"

How do I do this?

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Try Below:

Sum({<status={'Closed'},Product_Type={'Software','Hardware','Training'}>}Duration)/60

HTH
Sushil

View solution in original post

3 Replies
Highlighted
Partner
Partner

Hi,

Try this expression

sum({$<status={'Closed'}, Product_Type={"Software","Hardware","Training">} Duration/60)


Sergey

Regards,
Sergey
Highlighted
Master II
Master II

Try Below:

Sum({<status={'Closed'},Product_Type={'Software','Hardware','Training'}>}Duration)/60

HTH
Sushil

View solution in original post

Highlighted

Hi,

Try this

Sum({<status={'Closed'},Product_Type={'Software','Hardware','Training'}>}Duration)/60)


Regards

ASHFAQ