Discussion board where members can get started with Qlik Sense.
I'm trying to create a calculation that sums total number of instances where client's based off min date.
The objective would be to add addtional columns to count specific instances like primary reason for entry.
But for now, I'm just trying to get formula below to work.
=Sum(Aggr(If([Entry Date] = Min(TOTAL <[Client Id]> Floor(Num([Entry Date]))),1,0)
Go to Solution.
May be this
=Sum(Aggr(If([Entry Date] = Min(TOTAL <[Client Id]> Floor(Num([Entry Date]))),1,0), [Client Id], [Entry Date]))
Thank you. The formula worked. Why was there need to add extra [Client Id], [Entry Date] at end of the formula?
You only were closing the if statement... but need to add the dimensions for the Aggr() function....
ah, thank you.