Skip to Content
author's profile photo Former Member
Former Member

Multiple Selections on Category Axis

Hi,

I need to create a graph. On Category Axis ( X= axis) I need to show values of 5 keyfigures from a BW query. Y axis will be Values in thousand.

Currently no issues with Y-axis. But I am not able to figure out how I can have multiple category axis on X axis.

Basically what I need is a way of creating 1 category which has 5 KFs.

thanks,

Murtuza.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2010 at 04:02 PM

    Any thoughts or suggestion ? I'm still not able to figure this out

    Thanks,

    Murtuza

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello

      if you have all the mentioned 5 KF's in your query which is feeding the chart. Then in the chart you can add 5 series ... one for each KF's . you can label them as well accordingly. this should give you the 5 KF's on X axis with 1 Y axis for thousands

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2010 at 05:14 AM

    Hi

    Not very much clear with your requirement, i will take one example -

    On category axis you can show some infoobject like 'Plant Name' - so various plants will come on x-axis (Horizontally)

    In Data Series you can take key figures like 'opening,closing,issue, reciept stock' - so for each plant you will get these many columns (This will take the value in thousands as you want.)

    Are you looking for anything different?

    Regards

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you all for helping.

      Below is how I resolved :-

      I created a structure of table (Key Figures) in Column of query designer and then use that structure in VC to output table.

      There I had used formula for each KeyFigures using IF ...something like this:-

      NVAL(IF(@Key_Figures=="Prior Sales",0,IF(@Key_Figures=="Price",NVAL(IF(#ID[ACA257]@Price_Impact_value>=0,#ID[ACA257]@Prior_Sales_Value,#ID[ACA257]@Prior_Sales_Value+#ID[ACA257]@Price_Impact_value)),IF(@Key_Figures=="FX",#ID[ACA257]@GAP_3,IF(@Key_Figures=="Volume",#ID[ACA257]@GAP_4,IF(@Key_Figures=="Lost Mix",#ID[ACA257]@GAP_5_6,IF(@Key_Figures=="Gain Mix",#ID[ACA257]@GAP_5_6,IF(@Key_Figures=="Current Sales",0,123))))))))
      

      This way I got the output table as required.

      Thanks,

      Murtuza.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.