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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
StacyCui
Creator
Creator

Set Analysis Date

Dear

 Since we need a YTD as a date dimension in our business scope, we hope we can select it in a filter along with P1 to P12,  so I created a Master Calendar. and I wrote a 'YTD' so as to select it in a filter.

StacyCui_0-1663839586901.png

Here comes the filter screenshot. If I select 'YTD' , Order Table can be selected by the right date. So far, it's alright.

StacyCui_1-1663839649246.png

StacyCui_3-1663839966313.png

 

But When I selected 'YTD', the Total OR Value is 0.  I can't find where the wrong is?  

This is my set analysis:

Sum({ <FROZENDATE= {"<=$(=max(FROZENDATE))"},FY={'CY'}>} ORVALUE)

StacyCui_2-1663839689045.png

 

 

 

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Try this

Sum({ <FROZENDATE= {"<=$(=Date(Max(FROZENDATE), 'MM/DD/YYYY'))"},FY={'CY'}>} ORVALUE)