Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Need Help

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    ContriTarget Growth
ABC2,036,214.0060%1,907,892.0058%-0.063019899
BCA315,682.0054%313,682.0046%-0.00633549
ACD12,20033%12,500.0054%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....

5 Replies
qv_testing
Specialist II
Specialist II
Author

Anyone have Idea on This....

qv_testing
Specialist II
Specialist II
Author

is this possible in qlikview???

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

Thanks...

qv_testing
Specialist II
Specialist II
Author

Anyone is there??

swuehl
MVP
MVP

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

qv_testing
Specialist II
Specialist II
Author

Really very helpful to me......