topic Line Chart help in QlikView

Line Chart help

Tue, 09 Sep 2014 12:24:54 GMT

Hello,

I have a table something like this:

Year_Month Month Product SellOut SellIn

I created a line chart for the last 12 months by product:

and works fine, with X (Month) and a line for each product SellOut

When I introduce the expression Sum(SellIn), the X becomes Product and only two lines (SellOut and SellIn - product values sum) appear!!!

How can I resolve this?

Thanks in advance,

Francisco

alexandros17 — Tue, 09 Sep 2014 12:26:25 GMT

I think it is the normal behaviour of line chart with 2 dimension and 2 expression

Tue, 09 Sep 2014 12:37:21 GMT

OK, thanks...

So is there a way I can have a line chart (X - Month Y - Value), with 2 expressions lines for each product?

Note: some products have SellOut but no SellIn

Regards,

FLC

JonnyPoole — Tue, 09 Sep 2014 12:50:13 GMT

You can do that but you need to combine the dimensions and expressions so that you still only have 2 dims and 1 expression.

1. Load a table that has 2 fields: Metric and Metric value:

Metric will have either 2 values: 'Sellin' or 'Sellout'

MetricValue will have the numeric value from either column depending if its sellin or sellout

2. In the chart your 2nd dimension will be: Product & ' - ' & Metric , and the expression will be sum(MetricValue)

Here is a screenshot example below.