Need logic

[nareshthavidishetty]

Hi am having Customer ID and Application number

Scenario: A customer 'xyz' can apply to purchase a product on today for 3 times so count(Application number) for particular customer on that day is"3".

But here i need to capture information as one Customer on a particular day ,one application.

So finally i need to show customer 'xyz' Count(Application) =1

[sunny_talwar]

May be this:

=Count(Aggr(Count(DISTINCT Application), Customer, Day)

[PrashantSangle · Accepted solution]

Hi,

If Whenever Customer Purchase Product then generated Application Number is same or different for day.

If it is same then Sunny's Answer work.

If not then try below,

=Count(Aggr(Count(DISTINCT [Customer ID]), Day)

Regards

[nareshthavidishetty]

Thanks a lot sunny it works.

[sunny_talwar]

Awesome, I am glad I was able to help .

Thanks for taking time to mark my response as helpful, but I would also suggest closing this thread down by selecting a correct answer (and also mark other helpful answers).

Qlik Community Tip: Marking Replies as Correct or Helpful