topic Re: Conditions in Expression in QlikView

Conditions in Expression

bashar_f — Thu, 13 Nov 2014 05:40:02 GMT

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?

SergeyMak — Thu, 13 Nov 2014 05:41:40 GMT

Hi,

Try this expression

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

Sergey

sushil353 — Thu, 13 Nov 2014 05:44:57 GMT

Try Below:

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

HTH
Sushil

ashfaq_haseeb — Thu, 13 Nov 2014 06:17:09 GMT

Hi,

Try this

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

Regards

ASHFAQ