Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community
I'd be very greatful to receive some help, figuring out the following (for me) very challenging problem:
In broadcasting, we use the unit "Reach" to describe the share of viewers who have seen (at least one minute) of a program during the last X days. So imagine a table with the following columns, each record representing one minute of one viewer watching my TV channel:
During the last week (X=7), let's say Star trek aired a couple of times. But what is the "Reach"? What function can I use to get Qlik to tell me what share of viewers who have seen at least one minute of Star Trek during the last 7 days? (NB, since the weight is slightly changing every day, I need to use the average weight for each viewer over the 7 days.)
I'm looking forward to seeing some bright ideas on this! Thanks a lot!
Tor
NB: I cannot use set analysis to filter out the last 7 days, because I need to show the development of Reach over a periode, hence the function needs to refer to the last 7 days (rolling).
Have a look here: Calculating rolling n-period totals, averages or other aggregations
- Marcus
Have a look here: Calculating rolling n-period totals, averages or other aggregations
- Marcus
Thanks, Marcus! With a bit of struggle, I finally solved this with AsOf-tables, as suggested by the article.