Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
I'd like to build a like below chart in qlikview showing Target on X axis and Contribution % on Y axis.
I am attaching sample data in Qlikview file, but I don't know how to create this graph...
Example:
2014 | 2015 | ||||
Client | Target | Contri | Target | Contri | Target Growth |
ABC | 2,036,214.00 | 60% | 1,907,892.00 | 58% | -0.063019899 |
BCA | 315,682.00 | 54% | 313,682.00 | 46% | -0.00633549 |
ACD | 12,200 | 33% | 12,500.00 | 54% | 0.024590164 |
If user selection Year=2015
Month= Jan to March
Chart should be show
Year 2015 Vs 2014 in target Growth = (2015 target-2014 Target)
Month= Jan to Match of 2015 for Contri.
For Suppose ACD client..
TargetGrowth= 2.45%
Contribution= 54%
Hope you understand...
Thanks....
Anyone have Idea on This....
is this possible in qlikview???
If not possible, which chart should i take for that presentation??
Thanks...
Anyone is there??
IMO, you shouldn't expect help to arrive within minutes / few hours after posting a question.
Note that it is a week end for most community users and help offered by people is done in their spare time.
If you need help for urgent work (so I assume you get paid for this), I would suggest that you consider paying a consultant to help you.
Instead of waiting for help, you could have spent more time on creating sample data that better fits your requirement.
Looking at your data sample, your sales persons don't show data for two sequential years, so a year over year calculation is pretty hard given your sample data set.
I've attached a sample QVW with a scatter chart and some expressions, as far as I could get with your description and sample data.
That's all I can offer for today.
Regards,
Stefan
Really very helpful to me......