Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mambi
Contributor III

bar chart

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 :

img.jpg

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

Tags (2)
14 Replies
Not applicable

Re: bar chart

Will this do?

sum.png

Thanks,

Prabhu

mambi
Contributor III

Re: bar chart

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

Re: bar chart

Hi

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

And increase the weight as per attached file

Not applicable

Re: Re: bar chart

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;

Img.png

Thanks,
Prabhu

MVP
MVP

Re: bar chart

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

Also, confirm which edition you are using ?

i.e. Licensed or Personal...

Sample.JPG.jpg

Not applicable

Re: bar chart

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

Thanks,

Prabhu

mambi
Contributor III

Re: bar chart

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

thnaks

mambi
Contributor III

Re: bar chart

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

MVP
MVP

Re: bar chart

What could be the result?

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

Community Browser