Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

Expression

Please help me in the expression :

Screenshot

Capture.PNG

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Expression

Something like this?

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

View solution in original post

3 Replies
Partner
Partner

Re: Expression

Hi,

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

Highlighted
MVP
MVP

Re: Expression

Something like this?

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

View solution in original post

Highlighted
Valued Contributor II

Re: Expression

take variable, vShortDate and assign the expression

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