topic Line chart, 2 expressions in QlikView

Line chart, 2 expressions

Thu, 10 May 2012 10:03:04 GMT

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

(biff, embedded labels);

LOAD DISTINCT Date,

Article2,

Quantity2,

Price2,

Sum2,

Seller2

FROM

(biff, embedded labels);

Line chart, 2 expressions

jonathandienst — Thu, 10 May 2012 10:18:23 GMT

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

Thu, 10 May 2012 10:29:57 GMT

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

kji — Thu, 10 May 2012 12:15:35 GMT

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)).