Hi all,
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:
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):
(count( distinct if(open_rate < 0.15,[Campaign Code] ))) / (count( distinct [Campaign Code]))
Thank you very much!
SHapeman
