topic addmonths previous 30 days in QlikView

addmonths previous 30 days

ilanbaruch — Wed, 09 Mar 2016 07:32:43 GMT

hi all ,

i have a line chart with one expression that retrieve count value for every day.

i want to add an expression to count same value for the previous 30 days / 1 month

any ideas?

dimension is date DD-MMM-YY

first expression : Count({<invoice_count={1}>+<order_count={1},MM=>} DISTINCT client_id)

Re: addmonths previous 30 days

jagan — Wed, 09 Mar 2016 07:42:42 GMT

HI,

Try like this

=Count({<invoice_count={1}, MM=, DateFieldName={''>=$(=AddMonths(Max(DateFieldName), -1))<=$(=Date(Max(Date)))'}>+<order_count={1},MM=, DateFieldName={''>=$(=AddMonths(Max(DateFieldName), -1))<=$(=Date(Max(Date)))'}>} DISTINCT client_id)

Regards,

jagan.

Re: addmonths previous 30 days

Anonymous — Wed, 09 Mar 2016 07:45:58 GMT

did you check this?

Set Analysis for Rolling Periods

Set Analysis for certain Point in Time

Re: addmonths previous 30 days

tamilarasu — Wed, 09 Mar 2016 07:52:59 GMT

Hi,

Change DateField according to your application.

Count({<DateField={">=$(=Date(monthstart(addmonths(Max(DateField),-1)),'DD-MMM-YYYY'))<=$(=Date(Monthend(addmonths(Max(DateField),-1)),'DD-MMM-YYYY'))"},invoice_count={1}>

<DateField={">=$(=Date(monthstart(addmonths(Max(DateField),-1)),'DD-MMM-YYYY')) <=$(=Date(Monthend(addmonths(Max(DateField),-1)),'DD-MMM-YYYY'))"},

order_count={1},MM=>} DISTINCT client_id)