Pls help me for below logic - Qlik Community

abhaysingh · ‎2014-07-30

pls help me for below logic.

i have two types of customer i.e. new customer and existing customer

i want to show New vs Existing customer sale , month wise

now if i am showing New vs Existing sale in month of April than in next month new customer of april would be shown in existing customer of May and so on.....

pls pls do help me for that logic...

MK_QSL · ‎2014-07-30

Provide sample data... New and Existing Customers need to be classified in the script itself...

abhaysingh · ‎2014-07-30

i have customers and i have segregated on the basis of date.

i.e. customer those are enrolled after 31 march 2014 are new customer and rest of old customer

abhaysingh · ‎2014-07-30

* old customer = Existing customer

MK_QSL · ‎2014-07-30

What is your CustomerJoin Date looks like.. i.e. what format...? DD/MM/YYYY or DD MMM YYYY or any other?

avinashelite · ‎2014-07-30

Hi Abhay,

Please post the sample data.

Regards,

@vi