topic Re: Involved Customers in QlikView

Involved Customers

priyarane — Tue, 01 Mar 2016 09:30:48 GMT

hi Community,

I wanted to find involved customers sales for Existing Customers, New Customers, and Closed Customer.

Existing Customers sales= Sum of sales of Current and Previous

New Customers sales = Sum of sales of Current Customers and should not include Previous Customers.

Closed Customers sales = Sum of sales of Previous Customers and should not include Current Customers.

In my Dashboards,

1. I have Master Calender

2. Showing Current month and Previous month like below

3. Above Selections, I am storing in variables and those are using set like below.

Re: Involved Customers

swuehl — Tue, 01 Mar 2016 09:35:16 GMT

Have a look at

Re: New/Lost/Returning/Loyal Customers

Re: Involved Customers

priyarane — Tue, 01 Mar 2016 09:47:56 GMT

Thanks for the link. Here every thing need to change in Script part. Right now it is not possible to change script and I should do in Dashboard(front end) only.

Re: Involved Customers

swuehl — Tue, 01 Mar 2016 09:49:40 GMT

Look at the first few expressions that Gysbert used. AFAIR there are front end only, using set analysis and p() and e() function. This should work well if you select two periods to compare.

Re: Involved Customers

vikasmahajan — Tue, 01 Mar 2016 09:49:45 GMT

customer count, new,lost, total

Re: Involved Customers

Tue, 01 Mar 2016 10:54:49 GMT

Please try these expression.

For new customer sales

sum({$<Year={$(vCurrentyear)},Month={$(vCurrmonth)},Customer=(P{1<Year={$(vCurrentyear)}>}Customer)>}Sales)

For Closed Customers sales

sum({$<Year={$(vPrvyear)},Month={$(vPrvmonth)},Customer=(P{1<Year={$(vPrvyear)}>}Customer)>}Sales)

For Existing Customers sales

sum({$<Year={$(vCurrentyear),$(vPrvYear)},Month={$(vCurrmonth),$(vPrvMonth0},Customer=(P{1<Year={$(vCurrentyear),$(vPrvYear)}>}Customer)>}Sales)