topic Re: How to set expression to check the last 30 days? in QlikView

How to set expression to check the last 30 days?

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

Hello,

How Can I set the expression to my date column, so that it will filter only for the Last 30 days?

Re: How to set expression to check the last 30 days?

marinadorcassio1 — Thu, 11 Oct 2018 15:23:59 GMT

You should add a set analysis in your differents expressions in order to filter on the last 30 days.

Hope it helps,

Regard,

Marina

Re: How to set expression to check the last 30 days?

sudeepkm — Thu, 11 Oct 2018 15:24:50 GMT

something like below:

sum({<[Year Field]=,[Month Field]=, [Your Date Field]={">=$(=Date(Today()-30))<=$(=Today())"} >} SalesVolume)

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:26:49 GMT

I have added this expression but I am unable to get the last 30 days data

Sum({<Snapshot_Date = {">=$(=Addmonths(Max(Snapshot_Date),-1))"}>}Go_Live)

Re: How to set expression to check the last 30 days?

sunny_talwar — Thu, 11 Oct 2018 15:28:45 GMT

What is the format for Snapshot_Date?

Re: How to set expression to check the last 30 days?

dplr-rn — Thu, 11 Oct 2018 15:28:59 GMT

whats the dimensions in your chart?

if it has Snapshot_Date as a dimension the expression will not work

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:29:42 GMT

The format for Snapshot_Date is '2018-08-31'

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:30:30 GMT

I have Project Number as the Dimension and PAC Delay as Expression. I do not have Date in my Dimension

Re: How to set expression to check the last 30 days?

sunny_talwar — Thu, 11 Oct 2018 15:31:31 GMT

Try this

Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max(Snapshot_Date),-1), 'YYYY-MM-DD'))"}>} Go_Live)

Re: How to set expression to check the last 30 days?

dplr-rn — Thu, 11 Oct 2018 15:32:04 GMT

What is the output that you are getting

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:34:23 GMT

I tried using your expression, but the data is changing when I change the List Box filters

Re: How to set expression to check the last 30 days?

sunny_talwar — Thu, 11 Oct 2018 15:36:32 GMT

You mean that when you select Snapshot_Date the data changes? Try this may be

Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>} Go_Live)

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:45:11 GMT

It worked out, but I am getting the last two months data both July and August months data.

Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>} Go_Live)

Re: How to set expression to check the last 30 days?

sunny_talwar — Thu, 11 Oct 2018 15:50:00 GMT

What is your Max Snapshot_Date date? Without knowing what this date, it is difficult to know why you getting July and August

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 15:53:16 GMT

We need to put 0 instead -1 (0 for last month, -1 for two months, ...) here and it worked out. thank you Sunny

Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>} Go_Live)

Re: How to set expression to check the last 30 days?

bhaveshp90 — Thu, 11 Oct 2018 17:29:29 GMT

My Max Snapshot_Date is Previous month. If the Current month is October, Max Snapshot_Date is September