Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a bar chart that is calculating based on the sum of a field. I have the data values to show on the chart for the sum amount of 161,935 (see below).
However, I would like to show the COUNT as well, but only as a data point. So, ideally, the label would read 161,935 / (COUNT).
I have done this by adding another expression for COUNT(value), but that just brings up another bar with the count of the field.
Is there a way to show the count value in conjunction with the sum value as a data point?
Go to Solution.
Try a second expression in this way and select "value on data points" and unselect the rest of the display option.
= 161,935 &' ' & ' / ' &' ' & Count (field name).
You can add an expression that is not presented as a Bar (clear the Bar check box) and only shows Values on Data Points. For the value, use the Dual() function:
- the text part of the dual should calculate both values and concatenate them to form the desired look, such as SUM(COUNT)
- the numeric part of the dual should be the same as the bar expression, to ensure correct placement of the text.
The original expression in this case should not show Values on Data Points.
Make sure to format the Number for the second expression as "Expression Default"
www.masterssummit.com - take your QlikView skills to the next level!
Thank you for your response. I apologize for my delay.
I followed your instructions and tried the following dual function for one of the expressions:
dual(sum(VALUE) & count(VALUE),sum(VALUE))
but it looks like it just adds the sum and count together rather than giving me the sum/count as a data point.
Do you happen to have an example of how this may work?
dual(sum(VALUE) &''&'/'& count(VALUE),sum(VALUE))