topic Re: Max date to 3 Quarters data in QlikView

Max date to 3 Quarters data

NavinReddy — Fri, 19 Oct 2018 15:02:25 GMT

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

Re: Max date to 3 Quarters data

dplr-rn — Fri, 19 Oct 2018 15:19:06 GMT

Use something like below

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

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

Re: Max date to 3 Quarters data

NavinReddy — Fri, 19 Oct 2018 15:40:54 GMT

Hi Dilip,

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

Thank you,

Niranjan

Re: Max date to 3 Quarters data

dplr-rn — Fri, 19 Oct 2018 15:44:12 GMT

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)

Re: Max date to 3 Quarters data

NavinReddy — Fri, 19 Oct 2018 16:44:16 GMT

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

Re: Max date to 3 Quarters data

dplr-rn — Fri, 19 Oct 2018 17:11:21 GMT

Please explain what you mean by max Quarter month?

give me the date ranges

Re: Max date to 3 Quarters data

dplr-rn — Fri, 19 Oct 2018 17:12:33 GMT

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

Re: Max date to 3 Quarters data

NavinReddy — Fri, 19 Oct 2018 17:28:19 GMT

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

Re: Max date to 3 Quarters data

dplr-rn — Fri, 19 Oct 2018 17:33:25 GMT

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

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

variable is MonthStart(Max(Date))