topic Expressions with different dimensions in same chart in QlikView

Expressions with different dimensions in same chart

Mon, 04 Jun 2012 08:47:52 GMT

Hello everbody,

I wanted to know if it is possible in a line chart to have two expressions with different dimensions ?

Common dimensions : Period

1st expression : average of marks by period and by country

2nd expression : average of marks by period for all countries

Thank you

Expressions with different dimensions in same chart

Mon, 04 Jun 2012 08:58:12 GMT

Hi!

Well, you can achieve that particular effect by making having Period as dimension and then add an expression for each country and an expression for all the countries.

Example:

Expression 1

avg( {<Country{"USA"}>} Marks)

Expression 2

avg( {<Country{"UK"}>} Marks)

Expression 2

avg( {<Country{"*"}>} Marks)

This will show a line for each country and an average for all the countries.

Hope it help!

/Regards

Expressions with different dimensions in same chart

Tue, 05 Jun 2012 07:59:29 GMT

The problem is that I got numerous lines...

Re: Expressions with different dimensions in same chart

masha-ecraft — Tue, 05 Jun 2012 08:07:58 GMT

You can try the following:

Chart dimension: Period

1st expression: Avg(Marks)

2nd expression: avg(aggr(avg(Marks),Period, Country))

/Masha

Expressions with different dimensions in same chart

Tue, 05 Jun 2012 08:34:06 GMT

I got something very strange :

Expressions with different dimensions in same chart

masha-ecraft — Tue, 05 Jun 2012 09:16:22 GMT

Please add Period dimension to the list of aggregate parameters:

avg(aggr(avg(Marks),Period, Country))

Expressions with different dimensions in same chart

Tue, 05 Jun 2012 11:44:03 GMT

I tried but it still not working. I don't have my average by country but a global line...

Expressions with different dimensions in same chart

Tue, 05 Jun 2012 12:03:19 GMT

Hi,

Could you add an example where your solution is working? I would appreciate it alot since it would be neat to reduce the hardcoding

/regards

Expressions with different dimensions in same chart

masha-ecraft — Tue, 05 Jun 2012 12:43:53 GMT

Do you need one line for each country and one line showing global average?

In this case you should have 2 dimensions: Period and Country, and your expressions should be like that:

Global average: avg({<Country>} Mark)

Average by country: avg(Mark)

Expressions with different dimensions in same chart

Tue, 05 Jun 2012 14:18:06 GMT

It overlaps lines.

Re: Expressions with different dimensions in same chart

Nicole-Smith — Tue, 05 Jun 2012 16:01:10 GMT

You can overlay two charts (with the top one transparent) to get what you're looking for (see attached).

Expressions with different dimensions in same chart

masha-ecraft — Wed, 06 Jun 2012 07:20:13 GMT

pierre_35 wrote:
It overlaps lines.

Did you have Country as chart dimension?

Expressions with different dimensions in same chart

Thu, 07 Jun 2012 08:32:18 GMT

Yes I tried with and without counrty as a dimension.

I want to have something like that :

In black, my global international average and in green and orange, average for each of my countries. The goal is to compare average of each country with the global average.

Re: Expressions with different dimensions in same chart

Nicole-Smith — Thu, 07 Jun 2012 13:22:31 GMT

Overlaying the charts (like I mentioned above) is the only way for you to accomplish this. This is because with the QlikView line chart, you can have one dimension and multiple expressions or two dimensions and one expression, but you cannot have two dimensions and more than one expression.