topic Re: Line Chart with two dimensions and multiple expression in QlikView

Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 04:32:07 GMT

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.

Re: Line Chart with two dimensions and multiple expression

tresB — Tue, 22 Dec 2015 04:43:58 GMT

Enable trellies in dimension tab ?

Re: Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 04:51:22 GMT

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

Re: Line Chart with two dimensions and multiple expression

HirisH_V7 — Tue, 22 Dec 2015 04:54:18 GMT

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.

Re: Line Chart with two dimensions and multiple expression

tresB — Tue, 22 Dec 2015 04:56:09 GMT

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?

Re: Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 05:12:54 GMT

It has multiple expressions controlled by a list box

Re: Line Chart with two dimensions and multiple expression

tresB — Tue, 22 Dec 2015 05:15:59 GMT

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

Re: Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 08:27:54 GMT

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

pick function help?

Re: Line Chart with two dimensions and multiple expression

tresB — Tue, 22 Dec 2015 08:31:20 GMT

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

Re: Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 18:22:30 GMT

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.

Re: Line Chart with two dimensions and multiple expression

Tue, 22 Dec 2015 18:32:54 GMT

Thanks Hirish for the response,need to tweak your solution little bit to fit into my scope.

Re: Line Chart with two dimensions and multiple expression

HirisH_V7 — Wed, 23 Dec 2015 04:17:50 GMT

My pleasure.

-Hirish

Re: Line Chart with two dimensions and multiple expression

tresB — Wed, 23 Dec 2015 04:39:50 GMT

I am attaching the qvw that helps you meet your requirement (multiple dimensions - one exp. at a time) you started with. PFA

Re: Line Chart with two dimensions and multiple expression

Tue, 29 Dec 2015 16:50:21 GMT

Thanks Tresesco.....it helped!!!