topic Re: Finding Percentage In Table Box in QlikView

Finding Percentage In Table Box

Anonymous — Mon, 27 Aug 2018 06:45:52 GMT

Hi All,

In this table I have calculated Stock In Hand, Pending Order, Unsold Qty, Sold Qty and trying to calculate unsold percentage and sold percentage i.e Unsold Qty/ Stock In Hand

Formula for Unsold Qty is

if(((Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}Value))-

(Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}[Pending Order])))>0,

((Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}Value))-

(Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}[Pending Order]))))

and formula for Stock In Hand is

(Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}Value))

I am getting right values in the cells but Total value on the header is showing wrong information.

Please help me in correcting it.

Re: Finding Percentage In Table Box

tresB — Mon, 27 Aug 2018 06:52:59 GMT

One quick correction you can try like:

Wherever you used: date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy')

replace it with : date(today()-4,'dd/MM/yyyy')

i.e. - remove date#() and use 'MM' instead of 'mm'

Re: Finding Percentage In Table Box

Anonymous — Mon, 27 Aug 2018 07:02:43 GMT

This doesn't makes any difference , I think I need to use Aggr() function but how I need to use it here i am not understanding.

Re: Finding Percentage In Table Box

tresB — Mon, 27 Aug 2018 07:07:47 GMT

At least changing 'mm' to 'MM' should have given you a changed figure if even not the correct one. However, to come to your point about total mismatch, you could try like:

Sum(Aggr(<your existing exp>, Dim1, Dim2..)) // Dim1, Dim2... - are your chart dimensions

Re: Finding Percentage In Table Box

Anil_Babu_Samineni — Mon, 27 Aug 2018 07:18:30 GMT

May be this?

Sum(Aggr(

if(((Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}Value))-

(Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}[Pending Order])))>0,

((Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}Value))-

(Sum({<Common_Date={'$(=date(date#(today(),'mm/dd/yyyy')-4,'dd/mm/yyyy'))'}>}[Pending Order])))), Date, Item_NOC))