topic Re: Set Analysis New Customers in QlikView

Set Analysis New Customers

Thu, 05 Jun 2014 00:32:14 GMT

Hi All,

I have a requirement to find out sales of only new customers in a specific period. Could you please help me out with set analysis expression. I have attached the sample.

For the period Jan count should be 2, Feb 1, mar 2

Thanks,

Re: Set Analysis New Customers

jagan — Thu, 05 Jun 2014 02:14:21 GMT

Hi,

Arrive a flag in script for new customers and use it in set analysis, please find attached file for solution.

Regards,

Jagan.

Re: Set Analysis New Customers

Thu, 05 Jun 2014 02:19:17 GMT

Thanks Jagan. I don't want to modify the script now as I have a complex model. Isn't it possible to do directly from front end?

Thanks,

Re: Set Analysis New Customers

jagan — Thu, 05 Jun 2014 02:53:54 GMT

Hi,

Try this expressions

Jan : =Sum({$<ODate={">=2014-01-01<=2014-01-31"}>} Aggr(If(MonthName(Min(TOTAL <sCustomer> ODate)) = MonthName(ODate), Sum(sSales)), sCustomer, ODate))

Feb: =Sum({$<ODate={">=2014-02-01<=2014-02-28"}>} Aggr(If(MonthName(Min(TOTAL <sCustomer> ODate)) = MonthName(ODate), Sum(sSales)), sCustomer, ODate))

Mar: =Sum({$<ODate={">=2014-03-01<=2014-03-31"}>} Aggr(If(MonthName(Min(TOTAL <sCustomer> ODate)) = MonthName(ODate), Sum(sSales)), sCustomer, ODate))

Regards,

Jagan.