Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rwunderlich

New customer analysis using set analysis

I'm working on the classic new/lost customer problem using set analysis. I've found a few examples on the forum, but they don't seem to fit exactly what I'm after. I'm using the AsOf table approach with a "MonthsBack" field. Attached is a simple example of where I'm getting stuck.

I expected that the set

{ <MonthsBack={'0'}> - <MonthsBack={'>0<4'}>}

would give me Customers who ordered in the current month and did not order in the prior three months. It's not working. Any idea where I'm going wrong?

Thanks,

Rob



13 Replies
llauses243
Creator III
Creator III

Hi,

This post is very singular, is refered to customers, is refered to set analysis, with partipation of 3 big referents.

Thanks Rob, John y Oleg.

ecolomer
Master II
Master II

Yes is very very singular and very useful

Thank's for sharing

Saludos

EC

alexnimmosam
Contributor
Contributor

Yes, this is a great post, quite surprised there aren't many more New Customer analysis threads. This works well but takes an unsurprisingly long amount of time and consumes a large amount of resources when trying to calculate from a dataset with circa 10 million records over 15 months, and I will be required to expand this data set. Is this the most efficient way of doing this?

jaymeknapp
Contributor II
Contributor II

How do I set/get the 'MonthsBack' and 'AsOfYearMonth' ?