topic Re: Help me in below scenario? in QlikView

Help me in below scenario?

durgabhavani — Tue, 08 Sep 2015 18:37:06 GMT

Hi All,

Please find the attached qvw.

I need to calculate the total number of profiles in application.

One customer number is counted as one profile. But suppose the same customer having the same trigger id on same date then also we need to count that customer as one profile.

Please help me in counting the profiles.

Thanks,

Durga

Re: Help me in below scenario?

JonnyPoole — Tue, 08 Sep 2015 18:43:35 GMT

Not sure i understand what you are trying to count.

To count the number of records in the table with the Customer field use

count( Customer)

....If 'CustomerA' appears on two records it will count as 2

To count the number of unique values in the Customer field use:

count( distinct Customer)

....If 'CustomerA' appears on two records it will count as 1

If you want to count a customer as being different if they have the same customer value but a different trigger id then

count( distinct Customer&[Trigger ID])

If you want to count a customer as being different if they have the same customer value but a different DATE then

count( distinct Customer&DATE)

if you want to count a customer as being different if they have the same customer value but a different trigger id OR DATE then

count( distinct Customer&[Trigger ID]&DATE)

Re: Help me in below scenario?

Anonymous — Tue, 08 Sep 2015 18:44:01 GMT

have you tried count(total(Customer Number))?

Re: Help me in below scenario?

durgabhavani — Tue, 08 Sep 2015 19:08:07 GMT

Hi Jonathan,

Brilliant explanation. Everything is working fine but not last one. pls find screenshot.

Re: Help me in below scenario?

JonnyPoole — Tue, 08 Sep 2015 19:10:43 GMT

i think your data model has Date defined as: DATE

replace 'Date' with 'DATE' keeping everything else the same

Re: Help me in below scenario?

durgabhavani — Tue, 08 Sep 2015 19:13:32 GMT

Perfect Jonathan. Thanks a ton.