topic Re: Customized data points in the graph in QlikView

Customized data points in the graph

Thu, 25 Jun 2015 06:25:32 GMT

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.

Re: Customized data points in the graph

MK_QSL — Thu, 25 Jun 2015 06:37:02 GMT

Like this?

Re: Customized data points in the graph

hariprasadqv — Thu, 25 Jun 2015 06:44:15 GMT

Hi,

Write an expression for the desired value and select only values on Data Points in Expression Tab.

Re: Customized data points in the graph

Thu, 25 Jun 2015 06:56:34 GMT

Hi Manish, I tried the expression you provided but its still does not generating the output. My expressions are as follow,

FCR% = Sum (ELIGIBLE_SUM - REPEAT_7_SUM) / sum(ELIGIBLE_SUM)

No. of agents = Aggr(Num(SUM(ELIGIBLE_SUM - REPEAT_7_SUM)/SUM(ELIGIBLE_SUM),'#0%') & '--- ' &count(AGENT_AGS),Agents)

Note I want the count of agents, that had values for two fields used to compute FCR %. Two fields used ELIGIBLE_SUM and REPEAT_7_SUM.

Apologies upfront if I was not very clear. I'm new to the Qlikview community.

Re: Customized data points in the graph

Thu, 25 Jun 2015 06:58:37 GMT

Thanks. Would you have an example of how this can be achieved? I copied the fields above to what I was referring to. If you have an example it would really help.

Re: Customized data points in the graph

hariprasadqv — Thu, 25 Jun 2015 07:05:08 GMT

Hi,

PSA. It may help you.

Thanks

Re: Customized data points in the graph

MK_QSL — Thu, 25 Jun 2015 10:37:40 GMT

What is your Dimension?

Can you provide 5 to 10 lines sample data?

Re: Customized data points in the graph

Fri, 26 Jun 2015 00:03:37 GMT

Hi Guys,

I've attached a sample data set sourced for the graph and the Qlikview file. Just source the input file to the sample xlsx. Dimension is on Months.

As you can see the percentage on the individual data points is shown by FCR % field. I need to incorporate how many unique records were made up to show the percentage in each data point. Thanks.

Re: Customized data points in the graph

Fri, 26 Jun 2015 00:09:05 GMT

Hi Hari,

I have trouble opening the file with below error. I've included a sample data set plus the original qlikview file used. Can you help?

Re: Customized data points in the graph

hariprasadqv — Fri, 26 Jun 2015 04:00:44 GMT

Hi,

you are using Desktop Personal edition. So you can open only three QVW files which were developed in other mechine.

If you want to open open more you need to have Named CAL Leasing or PE License. For your Convenience i'm addings Script and snap shot of the UI Objects here.

Script

Sample:

LOAD * INLINE [

Satet, Product, Sales

AP, 101, 500

AP, 102, 200

DEL, 11, 200

DEL, 15, 130

DEL, 12, 145

UP, 356, 92

TN, 201, 65

TN, 202, 55

TN, 203, 96

];

Thanks

Re: Customized data points in the graph

Fri, 26 Jun 2015 05:20:19 GMT

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.

Re: Customized data points in the graph

hariprasadqv — Fri, 26 Jun 2015 05:36:02 GMT

Hi,

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

Re: Customized data points in the graph

hariprasadqv — Fri, 26 Jun 2015 05:50:43 GMT

Hi,

See the below Image, It may resolve your concern.

Thanks

Re: Customized data points in the graph

Fri, 26 Jun 2015 06:55:58 GMT

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%.

Re: Customized data points in the graph

hariprasadqv — Fri, 26 Jun 2015 07:09:12 GMT

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