topic Re: Set Analysis On previous 4 month in QlikView

Set Analysis On previous 4 month

jood_ahmad — Sun, 09 Aug 2015 07:42:02 GMT

Dears,

Can any one help me on this;

I need to get the new Customers & Old Customers from the customers table, the old customers that he inactive since 4 month and the new customer is active in the 4 month, i try to tack the max date -4 to get the count for customer(old) but did not work.

or how can i count the frequency for customer id in Max Month -4 (last 4 month)

Regards.

Message was edited by: Ahmad Kastero

Re: Set Analysis On previous 4 month

lironbaram — Sun, 09 Aug 2015 14:19:17 GMT

if you can use set analysis

with this expression for the dates

sum({<date={"$(=addmonths(max(date),-4))"}>})

Re: Set Analysis On previous 4 month

maxgro — Sun, 09 Aug 2015 16:00:25 GMT

=count({$ <date={"<=$(=Addmonths(max(d),-4))"}>} customer)

Re: Set Analysis On previous 4 month

jood_ahmad — Mon, 10 Aug 2015 07:52:09 GMT

Thank you But still not work

Re: Set Analysis On previous 4 month

jonas_rezende — Mon, 10 Aug 2015 14:53:28 GMT

Hi, ahmadkastero‌.

See if expression work like desired.

Count({1<%Date = {">=$(=MakeDate(Year(Max({1}%Date)-120),Month(Max({1}%Date)-120)))"} >} Customer)

The identifier can be modified of agree with your choice, example: $, 0,$1.

Hope this helps!