Sales many day but should count only first day

[Valerie]

One shop can sell many day, I wanted to count only the first day of unique shop first day sold.

Here is my data

Sales Date	Shop
2-May-19	A
2-May-19	B
2-May-19	A
3-May-19	A
4-May-19	B
5-May-19	C

Expected Result:

Sales Date	Count(distinct Shop)
2-May-19	2
5-May-19	1

I want to write expression in the Qlik Sense application that could count just the first record by day. Selection of month and year can varie.

What I acutally want is , once the record sold on 1st day, then will count as 1, if the same shop sold the next day  or any other day, shouldn't count.

[Sameer9585]

try this?

count(distinct "Sales Date")

[Valerie]

What I acutally want is , once the record sold on 1st day, then will count as 1, if the same shop sold the next day , shouldn't count.

[Sameer9585]

try this?

aggr(if(count(Shop)=1,Shop),Shop)

[sunny_talwar]

Why do you have a count of 1 on 3rd May? Shop A already sold on 2nd May....

[Sameer9585]

please look my thread I also have similar problem

https://community.qlik.com/t5/New-to-Qlik-Sense/Distinct-Data/m-p/1584419#M136503

[Sameer9585]

try this? This is working

aggr(if(count({"Sales Date"=}Shop)=1,Shop),Shop)

[Valerie]

I tried aggr(if(count({"Sales Date"=}Shop)=1,Shop),Shop) it doesn't work. 

[Valerie]

Your formula didn't work.

One shop can sell many day, I wanted to count only the first day of unique shop first day sold.

[Valerie]

Sorry my bad, I edited the result. 3rd May shouldn't be counted.