topic Re: Can't make a Bar Chart in QlikView

Can't make a Bar Chart

Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I'm trying to make a chart out of the Categories column but its shows no data to display. I need to show the categories as bar with the dollar amounts on the left. I don't know if to use dimensions or not just need to display the categories.

Please provide assistance.

Thanks in advance

Re: Can't make a Bar Chart

swuehl — Thu, 31 Mar 2016 22:04:45 GMT

Sorry, I haven't fully understood what you want to show.

Only category as dimension and then your expressions as grouped bars?

See attached for my current status

Re: Can't make a Bar Chart

swuehl — Thu, 31 Mar 2016 22:11:06 GMT

Ah, or maybe using a calculated dimension to re-calculated category:

=Aggr(

If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 500, 'Small',

If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 12000, 'Middle', 'Large'))

,[Customer Internal ID])

Re: Can't make a Bar Chart

Thu, 31 Mar 2016 22:12:49 GMT

Thanks for the response for categories I'm using a formula.

=If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 500, 'Small',

If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 12000, 'Middle', 'Large'))

I want to have something like this, instead having small middle and large instead of the months and the figures all the left.

Please provide assistance.

Re: Can't make a Bar Chart

swuehl — Thu, 31 Mar 2016 22:34:13 GMT

Have you seen my second answer above?

Re: Can't make a Bar Chart

Fri, 01 Apr 2016 12:11:05 GMT

Thanks Community Users, you guys are awesome always there to provide assistance!