topic Re: previous month filter date in QlikView

previous month filter date

Anonymous — Thu, 18 Oct 2018 04:24:05 GMT

Hello everyone,

I need to set an expression like this:

One is: if the user filter from aug 21º to sep 10º,

the other expresison needs to have the result of the same days but from the last month: jul 21º to aug 10º.

How could I do that?

e.g.

Diesel consumption:

from aug 21º to sep 10º = 21,2

set expression: jul 21º to aug 10º = 19,6

Tks

Re: previous month filter date

Sergey_Shuklin — Thu, 18 Oct 2018 05:14:30 GMT

Hello, Samuel!

In set expression you can use Addmonths() function with Max() or Min() for indicating a range of output dates.

Re: previous month filter date

jonathandienst — Thu, 18 Oct 2018 05:29:31 GMT

Something along this pattern:

Sum{<Date = {">=$(vMinDate) <=$(vMaxDate)"}>} Amount)

Sum{<Date = {">=$(=AddMonths(vMinDate, -1)) <=$(=AddMonths(vMaxDate, -1))"}, Month, Year>} Amount)

Assumes that the min and max are defined in the correct date format, that the fact table date field is called Date. I have also added overrides so that the date selection does not interfere with the second expression. If this does not work you will need more information to give more specific help.

Re: previous month filter date

Anonymous — Thu, 18 Oct 2018 23:29:54 GMT

Got it with this:

S_Date={'>=$(=addmonths(min(S_Date),-1))<=$(=addmonths(max(S_Date),-1))'}

Tks a lot,.

Re: previous month filter date

Anonymous — Thu, 18 Oct 2018 23:31:17 GMT

Tks for attention Jonathan.

Got it worked.

Gonna create variables to be faster.