topic Re: Selecting the 2 last months in QlikView

Selecting the 2 last months

Thu, 09 Jul 2015 14:26:54 GMT

Hey guys,

i trying to build a function which should select the last two months. With this function i am able to select the last month...

= Month(max({1}[Tatsächliche Einfahrt Datum]))

I want to activate this function when i switch to the next dokument...

Thank you

Re: Selecting the 2 last months

sunny_talwar — Thu, 09 Jul 2015 14:33:19 GMT

May be this:

='(' & Month(max({1}[Tatsächliche Einfahrt Datum])) & '|' & Month(AddMonths(Max({1}[Tatsächliche Einfahrt Datum]), -1)) & ')'

Re: Selecting the 2 last months

MK_QSL — Thu, 09 Jul 2015 14:38:28 GMT

=SUM({<InvoiceMonth=, InvoiceYear=, InvoiceQuarter=, InvoiceWeek=, InvoiceDate = {">=$(=MonthStart(Max({1}InvoiceDate),-1))<=$(=MonthEnd(Max({1}InvoiceDate)))"}>}Sales)

1) This will give you Total Sales for last two months.

2) I have bypassed InvoiceMonth,Year,Quarter, Week. So any selection made in those list box will not affect the end result.

Change InvoiceDate with [Tatsächliche Einfahrt Datum] and Sales with your respective fact data.

Re: Selecting the 2 last months

sunny_talwar — Thu, 09 Jul 2015 14:40:25 GMT

I thought he wanted Select in Field action expression . My bad

Re: Selecting the 2 last months

MK_QSL — Thu, 09 Jul 2015 14:44:02 GMT

Actually I also not understood what the question is... But just trying !

Re: Selecting the 2 last months

sunny_talwar — Thu, 09 Jul 2015 14:47:28 GMT

Hahahaha I guess between the two of us, we have got the base covered

Best,

Sunny