Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
i want to display data on bar chart 3 quarters data to max current date,
i have tried im not able to resolve the issue .
Please help me, i have attached the sample data.
Thanks in Advance
Niranjan
Use something like below
vLast3Quarter= Addmonths(Monthstart(Max(OrderDate)),-9)
Sum( {<OrderDate={">=$(=vLast3Quarter)"}>} OrderRecordCounter)
Hi Dilip,
Thanks for your reply, I want to display data on Chart Max Current date to Current Quarter.
Thank you,
Niranjan
Didnt understand your need properly. if you want the values between 2 dates
use below setanalysis and define your variables appropriately
Sum( {<OrderDate={">=$(=vLast3Quarter) <=$(=vYourMaxDate)"}>} OrderRecordCounter)
Hi Dilip,
Till Q3'2018 i have data but i can see 4 Quarters on chart, please help me to get max Quarter month to 3Quarters information. please find the qvw for your information
Thanks in Advance
Niranjan
Please explain what you mean by max Quarter month?
give me the date ranges
checked your qvw. you have not defined the variable vYourMaxDate.
Yes i have created the vYourMaxDate variable still im getting same data.
My Logic is -- from max current date to current QuarterStart i want to display the data
Thank you so much for your help
It does work. just change the <= to < in the set analysis i shared
Sum( {<OrderDate={">=$(=vLast3Quarter) <$(=vYourMaxDate)"}>} OrderRecordCounter).
variable is MonthStart(Max(Date))