Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
apichana
Contributor III
Contributor III

How to count record with have the same date

Please advise how to count no. of customer records buying any product on the same date . 

CustomerProduct  Transaction_Date
Axxx 01/01/2020 
Ayyy 01/01/2020
Azzz02/01/2020
Bxxx01/01/2020
Byyy01/01/2020
Bzzz01/01/2020
Bxxx02/01/2020
Czzz01/01/2020

 

Expected result 

CustomerTransaction DateCount
A01/01/20202
A02/01/20201
B01/01/20203
B02/01/20201
C01/01/20201

 

10 Replies
sunil_sawargave
Contributor III
Contributor III

Thanks for reply ,

sunil_sawargave_0-1664782005987.png

 

in one table there are no of date, no of SHOP NAME, NO Of REASON CODE

so iwant to Sum SCRAP COST having "same  SHOP NAME ", "Same REASON CODE", & same "DATE " with this condition

hope you get it my requirement.

Thnks

sunil