topic Re: Customer Counts for various conditions in QlikView

Customer Counts for various conditions

fazunus — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community Members,

I am working on customer count expressions for various conditions based on their contact activity in current period.Need help in some of the expressions to exclude some customers based on activity in the past.

For Ex. New Enquires ,the customer with "ENQ" codes are considered new for selected period but to exclude those who have any enquiry in last three months.

The details are in the attached sheet.

Re: Customer Counts for various conditions

avinashelite — Wed, 23 Jan 2019 07:26:43 GMT

Could you please share the sample data set and the required output ...that will help us to frame the expressions

Re: Customer Counts for various conditions

fazunus — Wed, 23 Jan 2019 07:53:47 GMT

Thanks for quick response.

I have attached the sample data files.

Regards,

Re: Customer Counts for various conditions

fazunus — Wed, 23 Jan 2019 08:16:56 GMT

Output Required is also attached.

Re: Customer Counts for various conditions

fazunus — Mon, 04 Feb 2019 11:16:28 GMT

Hi,

@avinashelite

Will you be able to help frame the expressions based on data provided.

Thanks for the support.

Regards,

Fazal