Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Involved Customers

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

Current n Pre.PNG

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

M n Y.PNG

1 Solution

Accepted Solutions
5 Replies
swuehl
MVP
MVP

priyarane
Specialist
Specialist
Author

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.

swuehl
MVP
MVP

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.

vikasmahajan

customer count, new,lost, total

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable

Hi

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)