I'm new to Qlikview and would love some help with this problem.
I have a Campaign_Code number with a one to many relationship with Campaign_Cell. My data is pre-aggregated at a Campaign_Cell level. I would like to do calculations with Campaign_Code, which would need to combine the Campaign_Cell stats for each Campaign_Code. How do I calculate at the campaign level?
Currently, I have my tables set up as a drill down. You click the Campaign_code and it reveals the Campaign_Cell.
Background:
I am trying to create a chart that shows the percentage of campaigns by their open rate. I already have them on the tab but it's deceiving because the open rate that I use for the dimension is actually the open rate at a CELL level and so a campaign can be counted more than once.
For example:
C01 25%
C02 18%
C03 15%
Further assume, I define three dimensions in the chart: <15%, 15-20%; >= 21% In this scenario, the single campaign will be counted THREE times – it will be counted in each range since it has one or more CELLS with an open rate in the given range. This is definitely not what I intended. So, the following expression won’t work (since the variable open_rate is calculated at cell level):
