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: 
morab
Contributor III
Contributor III

New Customer & Repeat Customer - Brand wise, Product wise by Date for selective month

Hi All,

Greetings from Bangladesh!! Heart

Here, attached is the "Dataset.xlsx" from which we want to derive few outputs (In Attachment) :

1. "Expected Result - By Brand.xlsx"

2. "Expected Result - By Product.xlsx"

Could you please help me?

Thanks in advance Smiley Happy

1 Solution

Accepted Solutions
sunny_talwar

Check attached now

View solution in original post

8 Replies
sunny_talwar

Please find attached a qvw sample where I have tried to match the numbers that you have in Excel. I have gotten very close, but don't match exactly. Not sure, but do you know why this would be the case?

morab
Contributor III
Contributor III
Author

Its too good man!!Smiley Happy

You are Fantastic!!Smiley Wink

Thanks a Ton!!!!HeartHeart

It's my bad, forget to mention - it should sum those placement where "Sales >0"  [Sum placement where sales is greater than Zero].

Can you please add this condition and share the reviewed QVW file with me.

Thanks again for your kind cooperation and prompt feedback. Smiley Happy Heart

sunny_talwar

Attached

morab
Contributor III
Contributor III
Author

Not exactly matching with the expected result. I have tried to match by modifying expression but can't . Need your kind cooperation.
sunny_talwar

Looked at a very specific example

Capture.PNG

You are saying on 8th April it was a new placement for outlet_code = 100034565, but the same outlet_code had it before on 1st April.

morab
Contributor III
Contributor III
Author

Valid point...!!

But, 100034565 outlet have only order value of 1.65 but sales value is zero on 1st April 2019, this why, we couldn't consider as new placement on 1st April 2019 whereas on 8th April, 100034565 outlet have both order and sales value e.g.1.65. so it would be consider as new placement.

Thumb rule : Outlet must be considered as successful placement if its sales value is greater than Zero.

Your kind cooperation on this regard will be highly appreciated.  

Thanks.HeartSmiley Happy

sunny_talwar

Check attached now

morab
Contributor III
Contributor III
Author

Thanks a lot..... Smiley Happy