Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

How to show repeat purchase..

Hi Everyone,

I want to show those customers who was repeated in next month..

stalwar1gwassenaar

Please help me with this issue..

Its really very very urgent....

Regards,

Kavita

22 Replies
kavita25
Partner - Specialist
Partner - Specialist
Author

I have already mentioned my problem....in the previous reply...

and i have attached the data also..

Kinldy check the qvw.

Its very urgent for me to do this by EOD.

swuehl
MVP
MVP

Search the forum for NEW, LOST, RETURNING customers, it seems you want to show something like this.

There are multiple approaches, if you want to compare fixed periods, you can also try set analysis: For example, to show outlets that had no sale in max month but sale in max month -2, something like

=Count(

{<[DMS Outlet Code] =

     e({<InvMonth = {"=InvMonth=$(=Max({1}InvMonth))"}>})*p({<InvMonth = {"=InvMonth=$(=Max({1}InvMonth))-2"}>} )

>}

DISTINCT [DMS Outlet Code])

kavita25
Partner - Specialist
Partner - Specialist
Author

Thanks a lott..Stefan..

Really thankful to you..for all the solutions...

Regards,

Kavita