Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi,

Use the expr like this in ur textobject

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

jagan
MVP
MVP

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
Author

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