Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

YTD calculation - need help with Set Analysis

Hi

I am trying to calculate YTD using DayNumberOfYear(). My calendar is FY, first month is Oct. In MasterCalendar I have added DayNumberOfYear(DateofSale,10) as DayNbrOfYear now in the set analysis I am trying to check a range if day falls between day 1 and the day number as of Today(). Problem is it is not giving me syntax error and not calculating it properly. For e.g as of today it should add up only day 1-142 it is adding up entire Year.

sum({$<DayNbrOfYear={">=1<=({DayNumberOfYear(today(),10)})"}>} Qty)

Please help. I am new to QV and have not much experience with Set Analysis.

Thanks

Rashid

1 Solution

Accepted Solutions

Try

sum({$<DayNbrOfYear={"<=$(=DayNumberOfYear(today(),10))"}>} Qty)

HIC

View solution in original post

2 Replies

Try

sum({$<DayNbrOfYear={"<=$(=DayNumberOfYear(today(),10))"}>} Qty)

HIC

View solution in original post

Creator
Creator

Thanks Henric! You are the Best