
Not applicable
2015-01-27
11:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
YTD
HI all how do i calculate YTD by months.
Current iam using the below formula which has monthNo in it .I want it to be by month .
=sum({$<Year={$(=Max(Year))},[MOnthNo]={"<=$(=(Max([MonthNo])"},Month=>}Sales)
This will give me ytd but every time i need to selsct monthno , I want the ytd to be displayed when i selsct month list box .
- Tags:
- new_to_qlikview
344 Views
2 Replies

Anonymous
Not applicable
2015-01-27
11:37 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
replace monthno --> Month field which is used for the display
233 Views


Master III
2015-01-27
11:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
try like this
Sum({<Year=, Month=, Datefiled={">=$(=Num(YearStart(Max(Datefiled))))<=$(=Max(Datefiled))"}>} Sales)
233 Views
