3 Replies Latest reply: May 10, 2012 8:15 AM by Johan Idh RSS

Line chart, 2 expressions

trash123

Hi,

I have the following problem. As you can see from the attached image (it is just a simple example) I have a line chart with 3 dimensions (date, seller, seller2) and 2 expressions: sum(price), sum(price2).

I want to have the possibility to select for example 2 sellers from the seller list box and 1 seller from the seller2 list box, and I should see 3 lines on the chart.

As for now I just see 1 line for each list box.

 

Thanks in advance

Michel

 

 

This is the code:

 

LOAD Date,

     Article,

     Quantity,

     Price,

     Sum,

     Seller

FROM

[C:\Documents and Settings\....sales.xls]

(biff, embedded labels);

 

LOAD DISTINCT Date,

     Article2,

     Quantity2,

     Price2,

     Sum2,

     Seller2

FROM

[C:\Documents and Settings\...sales2.xls]

(biff, embedded labels);

  • Line chart, 2 expressions
    jonathan dienst

    Hi

     

    If the question is how to select more than one value in a list box, press and hold CTRL while you make the selections.

     

    Whether one or many lines appear depends on how your defined your chart. I think you should post your app or a sample of it for more help on this.

     

    Regards

    Jonathan

    • Line chart, 2 expressions
      trash123

      Hi,

      the question was about showing more than one line on the chart.

      If I keep 1 dimension on the line chart, for example sum(price), then when I select more than one value in the first list box I see multiple lines which is correct.

      When I use 2 dimensions sum(price) and sum(prices2) I can't see multiple lines anymore.

      • Line chart, 2 expressions
        Johan Idh

        Multiple expressions will count as an expression, making the chart no longer using the second "real" dimension for its calculation (line chart is limited to at most 2 dimensions ( or 1 "real" dimension and multiple expressions)).