Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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