topic Re: Set Analysis in QlikView

Set Analysis

Fri, 06 Jun 2014 04:48:32 GMT

The year start is 03/04/2014 and 01/04/2013.

Data is available for the said dates but getting the opening stock as 0.

=Sum({$<DATE={$(date(min({<FinYear={$(=Max(FinYear))}>} DATE)))}>}OpeningStock)

Fri, 06 Jun 2014 04:52:13 GMT

Hi Uday,

could you please share the sample application QVW for better understanding.

-- Rajendra

tresB — Fri, 06 Jun 2014 05:06:48 GMT

If I see only at the expression, it has to be corrected like:

=Sum({$<DATE={"$(=date(min({<FinYear={"$(=Max(FinYear))"}>} DATE)))"}>}OpeningStock)

Fri, 06 Jun 2014 05:29:13 GMT

Thanks Tresesco. Its working .