topic Re: What is the syntax for trailing Quarter for last 90 days from Today? in QlikView

What is the syntax for trailing Quarter for last 90 days from Today?

arunqlik2view — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Please help me with the syntax for Trailing Quarter for past 90 days from today().

I'm trying to have a chart with 2 measures

1. Sum (Actual_Revenue)

2. Sum (Predicted_Revenue)

These two Measure should data only for last 90 days from Today.

the dimension for Date is "Date1"

Thanks in Advance,

Arun

sunny_talwar — Tue, 27 Nov 2018 12:27:34 GMT

May be try set analysis or a calculated dimension like this

If(Date1 >= Today() - 90, Date1)

and make sure to select 'Suppress When Value Is Null' on the dimension tab for the above dimension

arunqlik2view — Tue, 27 Nov 2018 12:54:07 GMT

Hi Sunny,

Thanks for the Quick reply. I got the chart, but I got them as individual bars for each day in the last 90 days.

Can I have it have as just 1 bar for all 90 days as Trailing Quarter.
Also it took like 3 or 4 days extra, I mean instead of 90 days , it seems like it took last 94 days.
The most recent date I have for the column Date1 is 26-11-2018 ,
so (26-11-2018 - 90 days) = 28-08-2018 , shows in excel.

Thank you,

Arun

sunny_talwar — Tue, 27 Nov 2018 13:03:29 GMT

1) Use this may be

If(Date1 >= Today() - 90, 'Trailing Quarter')

2) Difficult to say without seeing a sample

arunqlik2view — Wed, 28 Nov 2018 01:20:09 GMT

@ 2) Difficult to say without seeing a sample .

Here is the data I use and out put i get for last 90 days after using "=If(Date1 >= Today() - 90, Date1)" syntax.

Kindly take a look and let me know what Am I doing wrong.

Thanks,

Arun

arunqlik2view — Wed, 28 Nov 2018 01:50:47 GMT

data file

purna — Thu, 18 Nov 2021 04:54:05 GMT

Hello Sunny

Can you please give me the expression for last 60days sales value using addmonth

I have oct,nov,dec sales

Expression Given:

=sum({<Month={"$(=addmonth(max(Month)-2))>=$(addmonth(max(Month)))"}>}Sales)

Result:

But throwing the result same as sum(sales),but i want only last 60 days value, please help me in this

Thanks in advance

Purna.