Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies