Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

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)

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

View solution in original post

3 Replies
Not applicable
Author

Hi Uday,

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

-- Rajendra

tresesco
MVP
MVP

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

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

Not applicable
Author

Thanks Tresesco. Its working .