Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I Have data from Jan -01 -2017 to Current date
now i am showing data like this
Country daily MTD YTD this is table structure
A 10 20 300
now in filter sections iam displayig DailyDate
now if user selects May-05-2017 particular date this (Daily,MTD,YTD fileds are showing only single day data)
but i want daily filed (Single day data)
MTD Filed (user selcted May month so i want upto May-05-2017)
YTD (up to May-05-2017)
please help
thanks.
.
Hi Chaganti,
Can you provide us with a QVD?
Hi Chaganti,
try to use Set Analysis in your Expressions:
MTD = sum( {<Year = max(Year), Month = max(Month), Date = {"<=$(=date(Today()))"}>} ExpressionField)
YTD = sum( {<Year = max(Year), Month, Date = {"<=$(=date(Today()))"}>} ExpressionField)
BR
Martin