topic Re: 4-Grid Chart in QlikView

Need Help

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: 4-Grid Chart

Nagaraju_KCS — Sat, 02 Apr 2016 04:04:09 GMT

Anyone have Idea on This....

Re: 4-Grid Chart

Nagaraju_KCS — Sat, 02 Apr 2016 07:38:39 GMT

is this possible in qlikview???

If not possible, which chart should i take for that presentation??

Thanks...

Re: Need Help (4-Grid Chart)

Nagaraju_KCS — Sat, 02 Apr 2016 10:13:03 GMT

Anyone is there??

Re: Need Help (4-Grid Chart)

swuehl — Sat, 02 Apr 2016 11:01:24 GMT

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

Re: Need Help

Nagaraju_KCS — Wed, 06 Apr 2016 03:10:05 GMT

Really very helpful to me......