Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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