Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

KPI objects - use other variable in filtering

Hi guys and girls,

In my spreadsheet I have a table which counts per weekday the the average open rate, click rate and the numbers of e-mails sent. Below the table I would like a wall of fame, which should contain the following KPI-items:

- Best weekday in terms of average open rate

- Best weekday in terms of average click rate

- Worst weekday in terms of average open rate

- Worst weekday in terms of average click rate

Could you help me going in coding the formula? I'm stuck for some time now and could really use some help. Thanks in advance!

Jeroen