Customized data points in the graph

[#1]

Hi,

In my Qlikview line graph I've enabled data points over a period of 12 months that depicts a percentage. This is also the expression used in the graph. FCR% = sum(a)/sum(b), represented as a %. Now I'm trying to represent the number of records in the monthly data points  i.e count (field x) in addition to the percentage shown. I've tried this by addition another expression however this had distorted the view. Please help.

Graph

FCR_7% expression and shown as Values on Data Points, checked.

[#2]

Hi Hari,

I was working on the same thought process of attempting to map a second expression to the original percentage field. The problem I faced then, was the second expression (count) distorted the values represented in the graph. However the example you provided really helped. The trick was to un-tick line/symbol option on the secondary expression and just represent by the value on the data points. Thanks mate. Cheers.

[hariprasadqv]

Hi,

In this case you can go for represnting count as Value on Axis which is the next option.

[hariprasadqv]

Hi,

See the below Image, It may resolve your concern.

Thanks

[#5]

For some reason the expression with "DUAL" does not seem to work. It distorted the graph again. Could this be dual function having -70 as a static value. The values on the calculation is a much large value than FCR% represented hence could be why this is distorting again. Sample data set were copied earlier. I used,

=dual(num(count(AGENT_AGS),'%0'),sum(ELIGIBLE_SUM-REPEAT_7_SUM) - 70 + count(AGENT_AGS))

For data point 1 (months = 1), sum(ELIGIBLE_SUM-REPEAT_7_SUM) is 2919 but the FCR% is only 79.8%.

[hariprasadqv]

Hi,

Here 70 is the static value that is used to place Data points below the line. i.e if sum is 200 then the datapoint is placed at 200-70 ie. at 130 but the value won't change. Modify your expression according to that. It is advised to Enable simble with Auto attribute in the expression option above line.

Thanks