Discussion Board for collaboration related to QlikView App Development.
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
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)
View solution in original post
May be this:
=Count(Aggr(Count(DISTINCT Application), Customer, Day)
Thanks a lot sunny it works.
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