I am currently using the following fields:
Current YTD Sales
2013 Sales Goal
Names
Names is a many to one relationship with both of the other tables
I am attempting to make a grouped bar graph that has the names across the bottom with the grouping for each name being a bar representing current ytd sales and 2013 sales goals, then a key indicating the difference in the colors of the bars (only being two colors total)
The closest to this senerio I have gotten (that looks decent) is names in the map key showing the different color correlations then 2013 sales goals accross the bottom with the grouping being the the sales of each name thats in that sales goal. Then the x-axis being Sum of sales ytd
To give an idea I have an image of what I am trying to do
Does qlikview give me the freedom to make these customizations? If so what should I be looking to tweak?
With the expression as the axis, can't I just have it scale to a number? I see the option to do something similar, but it doesn't replace the expression and it does not let me remove the expression and show still show data.
If I could clear somethings up I will do my best. Thank you for your help