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

Sales many day but should count only first day

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 DateShop
2-May-19A
2-May-19B
2-May-19A
3-May-19A
4-May-19B
5-May-19

C

 

Expected Result:

Sales DateCount(distinct Shop)
2-May-192
5-May-191

 

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.

Labels (3)
11 Replies
sunny_talwar

May be this

Sum(Aggr(If(Shop <> Above(Shop), 1, 0), Shop, ([Sales Date], (NUMERIC))))
Sameer9585
Creator II
Creator II

Use Preceding Load.