topic Re: bar chart in QlikView

bar chart

mambi — Mon, 31 Mar 2014 10:48:39 GMT

Hi everyone,

from the sample data below ,

Month	Prod	Stock
Feb	A	10
Feb	B	20
Feb	C	30
Feb	D	40
Mar	A	20
Mar	B	39
Mar	C	34
Mar	D	23

i created this bar chart :

and now i want to know if it's possible to add a fifth (horizontal) bar to the chart (same chart) for the average ( Month : feb )

Thanks

Re: bar chart

Mon, 31 Mar 2014 10:59:55 GMT

Will this do?

Thanks,

Prabhu

Re: bar chart

mambi — Mon, 31 Mar 2014 11:04:30 GMT

i know this method but i want to add a horizontal bar

Re: bar chart

MayilVahanan — Mon, 31 Mar 2014 11:08:47 GMT

There is no option in bar chart. You can use the reference line

And increase the weight as per attached file

Re: Re: bar chart

Mon, 31 Mar 2014 11:26:14 GMT

Chk it out

test:

LOAD * INLINE [

mon, Prod, Stock

Feb, A, 10

Feb, B, 20

Feb, C, 30

Feb, D, 40

Mar, A, 20

Mar, B, 39

Mar, C, 34

Mar, D, 23

];

Concatenate

load mon, 'Avg' as Prod, avg(Stock) as Stock

Resident test

Group by mon;

Thanks,
Prabhu

Re: bar chart

MK_QSL — Mon, 31 Mar 2014 11:32:53 GMT

Like below... Please confirm... i will upload the trick...

Also, confirm which edition you are using ?

i.e. Licensed or Personal...

Re: bar chart

Tue, 01 Apr 2014 05:43:16 GMT

Please mark it as correct answer if the solution provided is suitable for you.

Thanks,

Prabhu

Re: bar chart

mambi — Tue, 01 Apr 2014 09:26:34 GMT

is there any method to get the same result using chart expression not in the load script ?

thnaks

Re: bar chart

mambi — Tue, 01 Apr 2014 09:27:50 GMT

thanks for your help but the results seems to be wrong !

Re: bar chart

MK_QSL — Tue, 01 Apr 2014 09:28:46 GMT

What could be the result?

Kindly let me know, I will check and confirm back...

Re: bar chart

sujeetsingh — Tue, 01 Apr 2014 09:32:12 GMT

You can add up the avg as Expression in UI

Re: bar chart

Tue, 01 Apr 2014 09:46:07 GMT

I really doubt if we can bring the same using chart expressions

Thanks,

Prabhu

Re: bar chart

MK_QSL — Tue, 01 Apr 2014 09:50:10 GMT

Give me the result you want.

Believe me .... I can do it..

Re: bar chart

mambi — Tue, 01 Apr 2014 11:05:34 GMT

exemple : for february the avg is 25

Re: bar chart

mambi — Tue, 01 Apr 2014 11:09:02 GMT

don't work because i have 2 dimensions and the bar chart will be stacked instead of grouped