Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Combo chart with values on line and two dimensions

Hi,

i have a problem with my combo chart which is showing different status of offers before and after a fair. I have two dimensions - name of the fair and the aggregated created date of the quote (before and after fair). My problem is that the line, which must display the values (number of quotes), is using the first dimension for the position of the values. But i want to use the second dimension - before and after. So that there is a value in each bar. Can anyone help me?

My view:

ComboChart.JPG

How it should look like:

ComboChart_new.JPG

Thanks for helping.

Theresa

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: Combo chart with values on line and two dimensions

Hi Theresa,

in the expression, you cold deactivate the line (only the line, not the entire expression) and enable the value on chart option.

At least, the values will be shown on top of the stacked bars, so the information will be visible.

Cheers,

Fabian

View solution in original post

9 Replies
Highlighted
Not applicable

Re: Combo chart with values on line and two dimensions

Attach your application if possible.

Highlighted
Contributor III
Contributor III

Re: Combo chart with values on line and two dimensions

Hi,

thanks for reply. See attached file.

Highlighted
Contributor III
Contributor III

Re: Combo chart with values on line and two dimensions

Is there anyone with a solution? Please!

Highlighted
Specialist II
Specialist II

Re: Combo chart with values on line and two dimensions

     Seems like your line would have to use both dimensions in order to display right. I'm not sure how to do that. Why don't you try combining your dimension into one? Try something like this as your dimension:

=if(Quotes.CreatedOn<Event.ecx_Startdate,'Fair Trade ' & Event.No & ' before','Fair Trade ' & Event.No & ' after')

Then to get right sorting, sort by expression with Event.No, then also click Text and sort Z-A.

Hopefully this helps.

Highlighted
Specialist
Specialist

Re: Combo chart with values on line and two dimensions

Hi,

In axes tab, take first two expressions as left bottom, and 3rd expression as right top and keep axes into 40%. Basically it is in 65% change it. Hope it helps you.

Regards,

Khadeer

Highlighted
Contributor III
Contributor III

Re: Combo chart with values on line and two dimensions

Hey jerem1234, thanks for your suggestion. Your right. I could do that. And looks like that this is the only way I could do it. But I thought that there would be a way to consider both dimensions, because it will display more clearly that there is one fair separeted into Quotes before the fair and after the fair. So when I do it the way you recommand the distance between the bars is always the same. So I lost my group of fairs.

But thanks a lot for your reply.

Highlighted
Contributor III
Contributor III

Re: Combo chart with values on line and two dimensions

Hi Khadeer,

i tried it. But it do not work. Maybe I did it the wrong way. Can you tell me what I did wrong?

Highlighted
Creator II
Creator II

Re: Combo chart with values on line and two dimensions

Hi Theresa,

in the expression, you cold deactivate the line (only the line, not the entire expression) and enable the value on chart option.

At least, the values will be shown on top of the stacked bars, so the information will be visible.

Cheers,

Fabian

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Combo chart with values on line and two dimensions

Hallo Herr Heidenstecker,

Sie haben jetzt 17 Punkte in der Community… Herzlichen Glückwunsch

Freundliche Grüße aus Solingen und eine schöne Urlaubswoche

Theresa Oehler

B.Sc

Controlling

Phone +49 212 6580-459

Fax +49 212 6580-370

E-mail t.oehler@item24.com<mailto:t.oehler@item24.com>

<http://www.item24.com>

<http://www.item24.de/en/company/company/detailview/news/new-work-bench-product-configurator-goes-online-10308.html>