Discussion Board for collaboration related to QlikView App Development.
Greetings from Bangladesh!!
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
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?
Its too good man!!
You are Fantastic!!
Thanks a Ton!!!!
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.
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.