Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have filters Date, Month, Year.
Taken date in X-axis and written the expression for rolling 30 days.
when I am selecting date, it is displaying that particular date only not previous 30 day.
please find the expression
Avg({<Day={">=$(=Date(max(Day)-30,'MM/DD/YYYY'))<=$(=Date(max(Day),'MM/DD/YYYY'))"}>}AssetRank)
could you suggest any mistakes I have done in this expression.
Please test this mode.
Variables
vMaxDate = Max(Day)
vMinDate = Date(Max(Day) - 30)
Formula:
AVG({<Day = {">=$(=$(vMinDate ))<=$(=$(vMaxDate )) "}>}AssetRank).
I think you need to ignore selection in Date, Year and Month field and assuming Day looks like this 07/12/2016 (full date), it will drive all your selections
Avg({<Day={">=$(=Date(max(Day)-30,'MM/DD/YYYY'))<=$(=Date(max(Day),'MM/DD/YYYY'))"}, Date, Month, Year>}AssetRank)
Hi Sunny,
thanks for your reply.
I have applied your expression still it is not working. whatever values I am selecting simply it is displaying that values only
dimension is in this below format.
Date(Day,'MMDD')
What is the difference between Date and Day?
Date column is not there, y mistake instead of Day I mentioned Date.
Can you share a sample?
Hi Sunny,
Please find the attached sample data.
This looks like an export from QlikView? Raw data or just the QVW app?
Hi Sunny,
Now I have attached the sample data. please find it.