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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
md_talib
Contributor III
Contributor III

MTD Data is Correct but YTD value is getting wrong.

I have to calculate the sum of MTD and YTD. 

MTD data is correct for each month but in YTD value is wrong. 

here is my expression 

Num(alt(Sum({< STAT_FLAG={"BUDGET"},[Fiscal Month],[FY Year Name],BUSINESS_DATE,

Posting_Date={">=$(vCalMinDateYtd) <=$(vCalMaxDate) "} >} NO_OF_GUEST_STAYED) /BUD_Day_Target,0),'#,##0')

here BUD_Day_Target is the no. of days in the month.

Labels (3)
0 Replies