This content has been marked as final. Show 2 replies
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!
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).