topic Calculated Dimension in QlikView

Calculated Dimension

tmumaw — Wed, 16 Feb 2011 17:53:07 GMT

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.

Thanks

=if(QTY - if(Status = 'NS',0,(count(Distinct WEDAT))) < QTY,'In-Process', [STATUS DESC])

Calculated Dimension

deepakk — Wed, 16 Feb 2011 18:13:17 GMT

hi,

when you are using calculated function like count or sum in calculated dimension we have to use aggr function.

aggr(count(t2), t1)..

Calculated Dimension

tmumaw — Wed, 16 Feb 2011 18:49:46 GMT

where would the aggr be placed and would I only use one?

Calculated Dimension

deepakk — Thu, 17 Feb 2011 10:24:27 GMT

hi,

I hope the attach application helps you out.