topic Re: Summary value for positive values only. in QlikView

Summary value for positive values only.

Wkong — Thu, 01 Jun 2023 05:07:49 GMT

Hey experts,

I am currently having trouble with making a dashboard. Suppose I have these values.

Where unsold is a calculation by subtracting the inventory by the number of orders.
How can I get the value on the KPI chart to display a summation of only the sum of the positive values?

Re: Summary value for positive values only.

tresB — Thu, 01 Jun 2023 05:47:30 GMT

Try something like:

Sum({<[Product number]={"=Sum(Inventory)-Sum(Order)>0"}>}(Inventory-Order))

Re: Summary value for positive values only.

Wkong — Thu, 01 Jun 2023 05:57:58 GMT

Using this expression returns: Error in expression, Error in set modifier ad hoc element list: ',' or ')' expected.
Here is what I currently have.
Sum(
{<[Product Number]={Sum(Weight)-Sum([Quantity Kg])>0},
[Refrigration Code]={C},
[Service Kill Code]={NO},
Category={BEEF},
Prodsite={BEE,DIN,RDL,ROC,TOW},
Site={BEE,DIN,RDL,ROC,TOW,JBD,HEM}
>}
(Weight-[Quantity Kg]))

Re: Summary value for positive values only.

tresB — Thu, 01 Jun 2023 06:15:46 GMT

Sum(
{<[Product Number]={"=Sum(Weight)-Sum([Quantity Kg])>0"},
[Refrigration Code]={C},
[Service Kill Code]={NO},
Category={BEEF},
Prodsite={BEE,DIN,RDL,ROC,TOW},
Site={BEE,DIN,RDL,ROC,TOW,JBD,HEM}
>}
(Weight-[Quantity Kg]))

Re: Summary value for positive values only.

BrunPierre — Thu, 01 Jun 2023 06:25:28 GMT

Try

RangeMax(Sum(Unsold), 0)