topic Re: Expression in QlikView

Expression

suvechha_b — Thu, 28 Jan 2016 08:47:48 GMT

Please help me in the expression :

Screenshot

Short Dated :

I want [Short Dated] as variable , $(vInvOnHold) i.e SUM(qty_available) +SUM(qty_blocked_qc)

when the reason_code=130

or else 0 .

Sample model attached.

Anonymous — Thu, 28 Jan 2016 08:59:33 GMT

Hi,

Please try this: if(reason_code = '130', sum($(vInvOnHold)),0)

MK_QSL — Thu, 28 Jan 2016 09:00:22 GMT

Something like this?

=IF(reason_code = 130, SUM({<reason_code = {'130'}>}qty_available) +SUM({<reason_code = {'130'}>}qty_blocked_qc),0)

PradeepReddy — Thu, 28 Jan 2016 09:09:21 GMT

take variable, vShortDate and assign the expression

=sum({$<reason_code={'130'}>}qty_available)+sum({$<reason_code={'130'}>}qty_blocked_qc)