Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

How to replace expression value

Attached picture is my scenario, this is PIVOT Table 1. ITC_Code is 'itemcode' 2. inv_shop_id_f is my 'shopid' 3. 'PC' in expression is the 'Status' showing that the these item codes are 'closed' at this shop Question is: I want to show the Balance in the box where Status is not 'PC', my expression for the balance calculation is 'sum(inv_qtyin)-Sum(inv_qtyout)'