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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
Anonymous
Not applicable
‎2014-07-31 01:31 PM

YTD with condition

I have to show YTD with condition like if  month selected is complete show YTD, if it is not complete(for ex: July 25,2014) show till June data.

like monthend(max(Calendermonthyear)=max(calendermonthyear), max(calendermonthyear)

     monthend(max(Calendermonthyear)>max(calendermonthyear),max(calendermonthyear)-1

right now Iam using this to find YTD

Capture.PNG

How do I modify expression to show above condition?

232 Views
0 Likes
0 Replies