Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
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||Count(distinct Shop)|
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.