topic Re: chart problem in QlikView

chart problem

Thu, 22 Aug 2013 06:38:57 GMT

I got this chart

showing amount af items sold in 2012 and 2013, - but items in 2013 consists of two groups ex. carlsberg and tuborg so i´d like the column for jan 2013 to be divided still in one column but with two colors and the amount inside segment.

I make this chart with two expressions

=count(if(year='2013',solditems)) and count(if(year='2012',solditems))

I´ve tried to add more dimensions but it fails

I want somthing like this

this is made with 3 dimension and one expression showing 2013 but then i´m missing 2012 as the dotted line?????

Re: chart problem

Thu, 22 Aug 2013 06:39:45 GMT

sorry - but I cant add sampledata

Re: chart problem

tresB — Thu, 22 Aug 2013 06:44:30 GMT

What is the chart type you are using? With chart type 'Combo Chart', this should work fine.

Re: chart problem

sparur — Thu, 22 Aug 2013 06:45:32 GMT

i think stack bar chart will help you.

go to chart properties -> Style tab and select SubType "Stacked"

Re: chart problem

Thu, 22 Aug 2013 06:48:05 GMT

I do use combo chart

Re: chart problem

Thu, 22 Aug 2013 06:53:01 GMT

Hey - I did not see that possibility - thanx - now I just need to separate 2012 and 2013 so 2012 is a dotted line and 2013 is stacked

Re: chart problem

er_mohit — Thu, 22 Aug 2013 06:59:36 GMT

add two expression for 2012 and 2013

hope it helps

Re: chart problem

Thu, 22 Aug 2013 07:00:15 GMT

You cant use stacked when using 2 expressions?? I only want stacked for 2013 and a dotted line for 2012??????

Re: chart problem

Thu, 22 Aug 2013 07:00:56 GMT

tried that - but doent work with 2 expressions

Re: chart problem

tresB — Thu, 22 Aug 2013 07:04:07 GMT

With Combo chart type:

Please check in the expression tab, if for the second expression, display options (Symbol and Line) are checked.

Re: chart problem

Thu, 22 Aug 2013 07:17:34 GMT

checked for 2013 is BAR and 2012 is checked for LINE

Re: chart problem

Thu, 22 Aug 2013 07:18:41 GMT

the subtype ind style tab is greyed out when using two expressions

Re: chart problem

Tue, 05 Nov 2013 12:36:40 GMT

Er det ikke bare en stacked barchart?

Men tidsdata præsenteres vel best som vidst med en liniegraph.

Men du burde godt kunne lave en stacked chart. Så årene kommer ovenpå hinanden.. Hvis jeg forstod dig korrekt

Re: chart problem

Tue, 05 Nov 2013 13:38:58 GMT

jo det var - beklager den manglende tilbage melding

Re: chart problem

Mon, 07 Apr 2014 10:51:36 GMT

Try this ... this will help u.....

Re: chart problem

ThornOfCrowns — Mon, 07 Apr 2014 10:56:25 GMT

Only six months too late.