topic Re: craete stackes bar chart in QlikView

craete stackes bar chart

Sat, 02 Aug 2014 21:00:38 GMT

I have one dimension and multi expression that each of these has average for himself (average is expression too)

I want to compare each of expression with its average by stacked bar chart but when I select stacked in style tab all of them stacked while I want only two by two these stacked

like this image that I create in excel

Re: craete stackes bar chart

ecolomer — Sun, 03 Aug 2014 21:54:59 GMT

Can you send me the file with the actual data

Enrique Colomer

Re: Re: craete stackes bar chart

Mon, 04 Aug 2014 14:19:47 GMT

Dear Enrique

I attached sample as you see in the file I have 3 expression that each of them have avg and my desired stackes chart is have 3 bar whit 2 color that show the difference

thanks

Enrique Colomer wrote:

Can you send me the file with the actual data

TX

Enrique Colomer

Re: Re: Re: craete stackes bar chart

ecolomer — Wed, 06 Aug 2014 04:06:30 GMT

I changed your file with:

- tipus of graphic (bars and line)

- change for each expresion type of representation

I don't know if is this you want?

Saludos,

Enrique

Re: Re: Re: Re: craete stackes bar chart

Wed, 06 Aug 2014 08:18:59 GMT

dear Enrique

Not exactly but your file was helpful and change my mind to use your tip.

I have another question that for each of employee I want to show 3parameter (like wage, bones and total for example) in line chart but when I use name of employee as dimension and wage, bones and total as expression but it show points instead of lines (when select only one person)

a sample I attach to see

thanks

Re: craete stackes bar chart

ecolomer — Wed, 06 Aug 2014 13:37:46 GMT

Hi Hossein,

I don't see the attached file ¿¿??

Con you send me them?

Re: craete stackes bar chart

ecolomer — Wed, 06 Aug 2014 13:44:35 GMT

I have your file

I'm sorry

Re: Re: craete stackes bar chart

ecolomer — Wed, 06 Aug 2014 13:51:36 GMT

I attach the file

Re: Re: Re: craete stackes bar chart

ecolomer — Wed, 06 Aug 2014 13:54:42 GMT

if you select a value of employee only you have a value for all de rest of variables and only you have a point in the graphic ¿ok?