topic Set analysis to get data for the previous month from date selection in QlikView

Set analysis to get data for the previous month from date selection

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

Hi,

How do get to a previous months set of data using set analysis?

If I have one selection of month logged with a date of 11/2016, I need data from 10/2016 to make % change

I have made 2 text boxes confirming the calculations bring back the correct numbers

num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))

num([MonthLogged])

But my set analysis fails to make a between statement

count({$<[Table]={'Open_Balance'},MonthLogged={">=$(=num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY')))<$(=num([MonthLogged]))"}>} %KEY_CaseIDR5_Open_Balance)

Where am I going wrong?

Thanks

Re: Set analysis to get data for the previous month from date selection

vishsaggi — Mon, 05 Dec 2016 16:17:46 GMT

Reference from Sunny's set analysis expression with regards to set analysis dates, Try this?

= count(

{ $< [Table]={'Open_Balance'},

MonthLogged ={"$(= '>=' & num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))) & '<' & num([MonthLogged]))"} >}

%KEY_CaseIDR5_Open_Balance

)

Re: Set analysis to get data for the previous month from date selection

muthukumar77 — Mon, 05 Dec 2016 16:55:43 GMT

Hi,

I hope it will be useful.

PFA

Re: Set analysis to get data for the previous month from date selection

everest226 — Tue, 06 Dec 2016 00:39:59 GMT

= count( { $< [Table]={'Open_Balance'},MonthLogged ={"$(= '>=' & num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))) & '<' & num([MonthLogged]))"} >}

%KEY_CaseIDR5_Open_Balance

)