topic Re: How to count record with have the same date in App Development

How to count record with have the same date

apichana — Mon, 14 Dec 2020 06:48:28 GMT

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

Customer	Product	Transaction_Date
A	xxx	01/01/2020
A	yyy	01/01/2020
A	zzz	02/01/2020
B	xxx	01/01/2020
B	yyy	01/01/2020
B	zzz	01/01/2020
B	xxx	02/01/2020
C	zzz	01/01/2020

Expected result

Customer	Transaction Date	Count
A	01/01/2020	2
A	02/01/2020	1
B	01/01/2020	3
B	02/01/2020	1
C	01/01/2020	1

Re: How to count record with have the same date

MayilVahanan — Mon, 14 Dec 2020 07:09:01 GMT

Hi @apichana

Try like below

Dim: Customer, Transaction Date

Measure: Count(Product)

Re: How to count record with have the same date

apichana — Mon, 14 Dec 2020 07:32:51 GMT

Hi Mayil Vahanan R,

Thank you so much for your advice. I got the result already. However, if I would like to add a calculation field for customers who have make a transaction on the same date more than 3 times per day. What would be the script to do that.

Re: How to count record with have the same date

MayilVahanan — Mon, 14 Dec 2020 10:58:52 GMT

Hi @apichana

Try like below

Sum(Aggr(If(count(distinct Transaction) > 3, 1, 0), Customer, Date))

Re: How to count record with have the same date

apichana — Tue, 15 Dec 2020 02:04:46 GMT

Hi Mayil Vahanan R,

Thank you for your advise. Sum(Aggr(If(count(distinct Transaction) > 3, 1, 0), Customer, Date)) -- > Transaction means field name that need to count right?

Re: How to count record with have the same date

MayilVahanan — Tue, 15 Dec 2020 02:20:26 GMT

Yes, it's ur transaction field name..

Re: How to count record with have the same date

apichana — Tue, 15 Dec 2020 02:37:56 GMT

Hi MayilVahanan,

It works now. Thank you so much for your help.

Re: How to count record with have the same date

Daniel_C — Wed, 10 Feb 2021 04:31:12 GMT

I am also having this issue. Kindly please provide any relevant solution.

tellthebell

Re: How to count record with have the same date

sunil_sawargave — Thu, 29 Sep 2022 07:20:04 GMT

Hello , i am new on qlik sense, pls

DATE	SHOP NAME	SCRAP COST
23/05/2022	A1	55.123
23/05/2022	A1	663.12
23/05/2022	A1	456.12

Required Output

Date	Shop Name	SUM of SCRAP COST
23/05/2022	A1	55.123+663.12+456.12

Re: How to count record with have the same date

MayilVahanan — Thu, 29 Sep 2022 08:12:01 GMT

You can create the table with Date and ShopName as Dimension

Measure: sum([SCRAP COST])

it will help you

Re: How to count record with have the same date

sunil_sawargave — Mon, 03 Oct 2022 07:28:41 GMT

Thanks for reply ,

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