topic Stacked Chart for Product with Target at Product Group Level in QlikView

Stacked Chart for Product with Target at Product Group Level

bismart — Thu, 23 Apr 2015 13:15:23 GMT

Wonder if this is possible...

I have a stacked chart showing Quantity by Store ID with each segment showing sales of individual products within a Product Group.

I want to add a target figure for each store but at a product Group Level and have the target figure appear above the stacks.

Thanks

sample of chart required...

Re: Stacked Chart for Product with Target at Product Group Level

Gysbert_Wassenaar — Thu, 23 Apr 2015 13:46:46 GMT

I think it's possible to do this in one chart, but it's probably easier to use two charts and put on on top of the other and make the background of the top chart transparent.

Re: Stacked Chart for Product with Target at Product Group Level

bismart — Thu, 23 Apr 2015 14:38:45 GMT

Thanks for the suggestion

Tried that but not very good solution as I lose the facility of interacting with the products in the chart if the Target chart is layered above and also lose visibility of the Target values if the actual quantity for the store exceed the target figure, should the Target chart be layered at the bottom

Re: Stacked Chart for Product with Target at Product Group Level

buzzy996 — Thu, 23 Apr 2015 14:42:27 GMT

may be u can try, by creating 2nd axis for target!