for each, aggregating data,

Wed, 27 Mar 2013 15:48:02 GMT

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:

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):

(count( distinct if(open_rate < 0.15,[Campaign Code] ))) / (count( distinct [Campaign Code]))

Thank you very much!

SHapeman

topic for each, aggregating data, in QlikView

for each, aggregating data,