How to tag Orders with YES/NO if customer name is same?

[#1]

Hi Guys,

I have requirement where I would like to tag the Order as dual Order if the following condition is matched

Condition :

If a Customer placing Order from same Store more then once on the same date then that order should be tagged as dual order.

As an example:

in below table, only Order ID 1 & 2 should be tagged as a Dual Order Because Order ID 3 has different order date.

OrderID	Customer Name	Product Name	Store Name	Order Date
1	Jon Snow	Bread	City Store	15/06/2016
2	Jon Snow	Milk	City Store	15/06/2016
3	Jon Snow	Sugar	Eastern Store	16/06/2016

What I am trying to Achieve:

I want to create a Straight table in QlikView which will have dimensions like (Customer Name, City, DOB, Product, Order Date etc..)

And I want to have an extra column 'Dual Product' and it should be YES or NO like below:

OrderID	Customer Name	Product Name	Store Name	Order Date	Dual Product?
1	Jon Snow	Bread	City Store	15/06/2016	Yes
2	Jon Snow	Milk	City Store	15/06/2016	Yes
3	Jon Snow	Sugar	Eastern Store	16/06/2016	No

My Data Model is like This.. (QVW Attached)

Hope it makes sense.

Thank you

[#2]

Thank you Antonio it worked !

[#3]

Hi Antonio,

How can I get the count of this 'Yes' and 'No'

I would like to count how many orders are Dual and how many are not dual

I tried following based on the answer to this post's question..

Count(TOTAL <Name,OrderDate,StoreName> OrderId) > 1

But I am getting incorrect total

Thanks

[antoniotiman]

Try

Count(TOTAL <Name,OrderDate,StoreName> OrderId)