topic Re: creating Bar chart with two bars in QlikView

creating Bar chart with two bars

Mon, 22 Jul 2013 06:10:19 GMT

Hi Friends,

I have two fields [paid amount] and discount..
Now i want to create a bar chart where i can see two bars of [paid amount] and discount on monthwise.....

thanks and regards,

Hitesh

Re: creating Bar chart with two bars

er_mohit — Mon, 22 Jul 2013 06:16:52 GMT

Take Dimension Month

add two expression

sum( [paid amount] )

sum(discount)

and in style choose grouped and orientation

and in color tab uncheck persistant color

hope it helps

Re: creating Bar chart with two bars

nizamsha — Mon, 22 Jul 2013 06:29:02 GMT

if u want single bar for ur expression mean

sum(paidamount)

sum(discount)

then u neet staced its in the style tab if u want single color mean then uncheck the persistant check box if u want two color for the single bar mean then check the persistant color in style tab

Re: creating Bar chart with two bars

Mon, 22 Jul 2013 06:41:56 GMT

Hi ,

It is showing only paid amount bar....

I want both paid amount and discount bar side by side....

thnks

Re: creating Bar chart with two bars

er_mohit — Mon, 22 Jul 2013 06:45:54 GMT

i think there is data problem thats y it didn't show you try to uncheck the suppress zero value in presentation tab

Re: creating Bar chart with two bars

Mon, 22 Jul 2013 06:47:34 GMT

Hi ,

thnks it worked properly