topic Visualization Question - Vertical Measures with Comparisons to Peers in QlikView https://community.qlik.com/t5/QlikView/Visualization-Question-Vertical-Measures-with-Comparisons-to/m-p/462259#M558368 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm wondering if there is a better way to create the visualization I am about to describe.&nbsp; Hopefully one of you has already figured this out!</P><P></P><P>I have a set of measures that I need to display in a tabular format.&nbsp; For each measure I need to display the measure value for the person being scored along with the aggregate score of their peers and a benchmark that they are being compared against.</P><P></P><P>Currently the way I am doing this is I am creating each measure as a dimension.&nbsp; I then create three expressions using set analysis to control which measures display in my chart and to define the peer groups:</P><P> - Expression 1: self score</P><P>- Expression 2: peer group score</P><P>- Expression 3: benchmark</P><P></P><P>Some of these measures are rolling-N month measures, others are ratios of two measures and others are various permutations of multiple measures (ex: Measure 1 + Measure 2 / Measure 3 * Measure 4 ...).&nbsp; In order to get these trickier measures to display I have to create a row in my measure dimension for these measures and then pre-calculate these in my load script.&nbsp; To make matters worse some measures are just a sum of the numerator, others are a ratio of the numerator and denominator and others are an average of the numerator.&nbsp; <SPAN style="font-size: 10pt;">This kind of defeats the unique ability of QlikView to aggregate (correctly) on the fly based on user selections.</SPAN></P><P></P><P>Is there a better way to create a chart like this?&nbsp; I have attached an Excel document if it explains my scenario better.&nbsp; The only other option I came up with was to create one chart for each measure, using a calculated dimension to display plain text as the measure name and then layering the charts on top of each other to present the illusion of a single chart.&nbsp; This works fine until you run into a person that doesn't have values for all of the possible measures.&nbsp; Some measures are specific to the department that the person is working in so I cannot guarantee that each person will always have the same ten measures displayed.</P><P></P><P>Chris</P></BODY></HTML> Tue, 11 Jun 2013 15:59:16 GMT 2013-06-11T15:59:16Z Visualization Question - Vertical Measures with Comparisons to Peers https://community.qlik.com/t5/QlikView/Visualization-Question-Vertical-Measures-with-Comparisons-to/m-p/462259#M558368 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm wondering if there is a better way to create the visualization I am about to describe.&nbsp; Hopefully one of you has already figured this out!</P><P></P><P>I have a set of measures that I need to display in a tabular format.&nbsp; For each measure I need to display the measure value for the person being scored along with the aggregate score of their peers and a benchmark that they are being compared against.</P><P></P><P>Currently the way I am doing this is I am creating each measure as a dimension.&nbsp; I then create three expressions using set analysis to control which measures display in my chart and to define the peer groups:</P><P> - Expression 1: self score</P><P>- Expression 2: peer group score</P><P>- Expression 3: benchmark</P><P></P><P>Some of these measures are rolling-N month measures, others are ratios of two measures and others are various permutations of multiple measures (ex: Measure 1 + Measure 2 / Measure 3 * Measure 4 ...).&nbsp; In order to get these trickier measures to display I have to create a row in my measure dimension for these measures and then pre-calculate these in my load script.&nbsp; To make matters worse some measures are just a sum of the numerator, others are a ratio of the numerator and denominator and others are an average of the numerator.&nbsp; <SPAN style="font-size: 10pt;">This kind of defeats the unique ability of QlikView to aggregate (correctly) on the fly based on user selections.</SPAN></P><P></P><P>Is there a better way to create a chart like this?&nbsp; I have attached an Excel document if it explains my scenario better.&nbsp; The only other option I came up with was to create one chart for each measure, using a calculated dimension to display plain text as the measure name and then layering the charts on top of each other to present the illusion of a single chart.&nbsp; This works fine until you run into a person that doesn't have values for all of the possible measures.&nbsp; Some measures are specific to the department that the person is working in so I cannot guarantee that each person will always have the same ten measures displayed.</P><P></P><P>Chris</P></BODY></HTML> Tue, 11 Jun 2013 15:59:16 GMT https://community.qlik.com/t5/QlikView/Visualization-Question-Vertical-Measures-with-Comparisons-to/m-p/462259#M558368 2013-06-11T15:59:16Z