Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-08-27 02:29 PM

Dynamic Ytd from selection

Hi,

I'm currently trying create a YTD Sales values for a selected date
I've done YTD with a calendar script in a previous app with: inyeartodate(Date, '$(vtoday)', 0) * -1 AS YTD

Our customer wants to have the ability to select day, month and year and based on the selected date they want to see YTD values in a chart.

I'm writing the selection to the variable v_dateselection.

I'm not sure what's the best way to do this. Can someone help me? Thanks.

3,483 Views
0 Likes
10 Replies
Not applicable
‎2011-08-31 12:40 PM
Author

In response to stuartbeet

Something like this could work, I think:

=yearstart(addmonths(max(Datefield),-12))

199 Views
0 Likes