topic Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/219089#M72136 <HTML><HEAD></HEAD><BODY><P>Thom,</P><P>Might be overly simplistic but try putting a sum() round each of the 'QTY' entries.</P><P>If that doesn't work I'd post a sample file as what you're trying is entirely possible.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Wed, 16 Feb 2011 18:57:24 GMT matt_crowther 2011-02-16T18:57:24Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/219088#M72135 <HTML><HEAD></HEAD><BODY><P>Ok guys need a little help with calculated dimensions (Haven't went down this route yet). I have 2 fields QTY and TIMES WORKED. I am trying to get a simple status. This is what I have tried but with no luck. If the statement is true I want to use the literal 'In-Process' else the actual status description.</P><P>Thanks</P><P>=if(QTY - if(Status = 'NS',0,(count(Distinct WEDAT))) &lt; QTY,'In-Process', [STATUS DESC])</P></BODY></HTML> Wed, 16 Feb 2011 17:52:58 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/219088#M72135 tmumaw 2011-02-16T17:52:58Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/219089#M72136 <HTML><HEAD></HEAD><BODY><P>Thom,</P><P>Might be overly simplistic but try putting a sum() round each of the 'QTY' entries.</P><P>If that doesn't work I'd post a sample file as what you're trying is entirely possible.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Wed, 16 Feb 2011 18:57:24 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/219089#M72136 matt_crowther 2011-02-16T18:57:24Z