topic Re: Need logic in QlikView

Need logic

nareshthavidishetty — Tue, 02 Feb 2016 10:34:21 GMT

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

Re: Need logic

sunny_talwar — Tue, 02 Feb 2016 10:37:36 GMT

May be this:

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

Re: Need logic

PrashantSangle — Tue, 02 Feb 2016 10:55:12 GMT

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

Re: Need logic

nareshthavidishetty — Tue, 02 Feb 2016 10:55:42 GMT

Thanks a lot sunny it works.

Re: Need logic

sunny_talwar — Tue, 02 Feb 2016 11:16:16 GMT

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