Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

I want to draw a combo chart but getting flat line

I want to draw a combo chart but getting flat line.Kindly refer to attachment.

10 Replies
Not applicable

Re: I want to draw a combo chart but getting flat line

sorry by mistake I uploaded the same jpg file.But can any body help me with the excel data that how can we create a combo chart using this data where we'll have year,quarter & month and bar will be for sum(area),whereas line will be for sum(revenue).

tulasiram_bitra
New Contributor III

Re: I want to draw a combo chart but getting flat line

Hi Amit,

PFA. If it is not a solution for this, then plz Share Qvw.

Re: I want to draw a combo chart but getting flat line

Can you show how you have configured the expressions tab of your combo chart?

One expression should be defined with the Display Option set to Bar,

the other expression should use the Display Option of Line.

Partner
Partner

Re: I want to draw a combo chart but getting flat line

Hi Amit,

I have just loaded your data and get this:

check out the attachment

HTH Andy

Chanty4u
Esteemed Contributor III

Re: I want to draw a combo chart but getting flat line

is this?

Not applicable

Re: I want to draw a combo chart but getting flat line

I want to keep three dimensions in X axis i.e. year,quarter & month.

tulasiram_bitra
New Contributor III

Re: I want to draw a combo chart but getting flat line

Hi,

PFA

Not applicable

Re: I want to draw a combo chart but getting flat line

I am using Personal edition which is not allowing me to open ur file due to some license issue.

Although I am attaching the output which I am getting. Also Kindly observe that ideally 24 months must come in the scale for 2 yr.But I am getting 48 months.

PFA

Not applicable

Re: I want to draw a combo chart but getting flat line

PFA.