Line Chart with two dimensions and multiple expression

[#1]

Hi,

Is there any way to create a line chart with two dimensions(Quarter & Type) and multiple expressions.

Eg: To create a line chart with multiple lines for the second dimension Type and Quarter on X-Axis,for multiple metrics Sales/Discounts

The Expression for Sales should loop for all the  values of the field 'Type'

Any help would be appreciated.

[tresesco]

Enable trellies in dimension tab ?

[#3]

Thank You for the prompt reply....all I need is to have multiple lines of sales spread across various quarters on X-axis for all the possible values of te field 'Type'

Scenario:Type has four field values(Good,Bad,Average,Excellent)

So the output should have 4 lines of sales spread across the quarter

[HirisH_V7]

Hi John,

You can use Cyclic Approach for availing 2 dimensions in Line chart like this,

By creating a cyclic group for Customer and quarter you can view two dimensions.

Or else

If you need two dimensions at same  time means ,You can go with the Combo Chart out put will be like this below,

Hope this helps,

PFA,

Regards,

Hirish.

[tresesco]

If it is with single expression(sales), should be pretty simple using line chart itself. Take like:

Dim 1: Quarters

Dim 2: Type

Exp: Sum(Sales)

Am I missing something?

[#6]

It has multiple expressions controlled by a list box

[tresesco]

Do you allow multiple expressions be active at a time? If so, you can't achive that using a line chart (unless go for trellies).

[#8]

Multiple expression with conditional show,one expression at a time.....does

pick function help?

[tresesco]

It should work even without pick(). Could you attach your sample qvw?

[#10]

Hi,

I just created a similar scenario chart,what the user expect to see is when he/she hits the 'Show All Types' button,the line chart should show all the 'Type' Net Sales/Gross Sales except the two types already selected through input box.

Hope this could help you to find a solution.