Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can we fix Hardcoding in Visualisation??

 

if(GetSelectedCount([Month])=0 and GetSelectedCount([Fiscal Year])=0,

 

 

num(sum({<calendar_current_month_offset={'$(vDefaultMonthABCInventory)'}, month_end_metric_date_key={'20161031'}>}forecast),'#,##0'), The set analysis should be when the month_end_date_key = month_end_metric_date_key

 

 

num(sum({<calendar_year_month =  {'$(=Max(calendar_year_month))'}>}forecast),'#,##0')

 

)

   

23 Replies
Not applicable
Author

I am not sure if my understanding is correct?  When you say the date you need is 20161031 does it mean you are looking for the current month end date

Not applicable
Author

Yes True ..Current Month

Not applicable
Author

Ca you please try the below

Let varMaxDate = Date(MonthEnd(today()),'YYYYMMDD');

mohitd910
Creator II
Creator II

You Can use monthStart  , Month End Function