Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to calculate last3months distinct outlet coverage

Hi,

I want to show Last 3months distinct outlet coverage in text object.For Month-wise outlet count is coming correctly in my application.

Can any one know How to calculate Last 3month distinct outlet coverage.

Regards,

ba

3 Replies
Not applicable

How to calculate last3months distinct outlet coverage

Hi,

Use the expr like this in ur textobject

=sum({<MonthNo={2}>+<MonthNo={3}>+<MonthNo={4}>}  DISTINCT Outlet)

MVP
MVP

How to calculate last3months distinct outlet coverage

Hi,

Use this expression

=Count({<DateFieldName={'>=$(=AddMonths(Max(DateFieldName), -2))<=$(=Max(DateFieldName))'}>} DISTINCT outlet )

In above expression replace DateFieldName with your date field name.

Hope this helps you.

Regards,

Jagan.

Not applicable

How to calculate last3months distinct outlet coverage

Hi Sweth and Jagan,

Thanks for ur reply,

Can u please explain these in detaily.I used this expresion but it is showing some error.

thanks,

regards,

ba

Community Browser