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.
FCR_7% expression and shown as Values on Data Points, checked.
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.
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.
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.
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.
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