Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Need logic

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

1 Solution

Accepted Solutions
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

4 Replies
sunny_talwar

May be this:

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

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

nareshthavidishetty
Creator III
Creator III
Author

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