Showing the trends

[Anonymous]

am showing a current view(monyear) data, bt now i need to show the trend two year's data bt it shud be dynamic, it shud pickup by default. How to do that.

[Anil_Babu_Samineni]

This information won't make to reply. But, I will try my best (This is just imagination)

Avg({<monyear = {">=$(=AddYears(Max(monyear),-2))<=$(=Max(monyear))"}>} Sales)

[Anonymous]

there has to be a dynamic script as in when we load the data from our qvd,it shud identify by default which year month u r luking at so if the qvd is refreshed in jan ,it shud uphold 12 years data

[Anonymous]

every month when new data comes in ,am not required to change monyear in the script,it shud be all automated

[Anonymous]

can u please help regarding the same.

[Anonymous]

kindly help as its a urgent requirement.

[avinashelite]

if you have a data field like Month_Year then in your load statement

LOAD

*

from

QVD

Where  Month_Year =>MonthName(AddMonths(Today(),-12)) and Month_Year <=MonthName(Today());

NOTE: I have assumed month_Year format as e.g Feb 2018

[Anonymous]

thanks,

am doing the same thing in my where condition but its not wrking for me ,

[avinashelite]

share the sample app then will check and suggest

[Anonymous]

there is an issue with the date field format ,tahts why its not picking up I guess

how to correct the date format