Max date to 3 Quarters data

[NavinReddy]

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

[dplr-rn]

Use something like below

vLast3Quarter= Addmonths(Monthstart(Max(OrderDate)),-9)

Sum( {<OrderDate={">=$(=vLast3Quarter)"}>} OrderRecordCounter)

[NavinReddy]

Hi Dilip,

Thanks for your reply, I want to display data on Chart Max Current date to Current Quarter.

Thank you,

Niranjan

[dplr-rn]

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)

[NavinReddy]

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

[dplr-rn]

Please explain what you mean by max Quarter month?

give me the date ranges

[dplr-rn]

checked your qvw. you have not defined the variable vYourMaxDate.

[NavinReddy]

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

[dplr-rn]

It does work. just change the <= to < in the set analysis i shared

Sum( {<OrderDate={">=$(=vLast3Quarter) <$(=vYourMaxDate)"}>} OrderRecordCounter).

variable is MonthStart(Max(Date))