Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
user08192
New Contributor

Combining all bars into a single bar in a chart

I'd like to combine all of the bars in a bar chart to produce a second. The second one is just a single bar that shows the overall total.

For instance, if I have 6 bars on my graph "Farm Animals," with each bar representing a single animal (i.e., 10 pigs, 5 horses, 7 sheep, etc.). The second (separate) graph should have the label of "Total Animals" on the x-axis and a bar showing 41 total farm animals.

I don't want a stacked bar chart, per se. Just a single blue bar showing the total animals.

Is there any way to do this in Qlik Sense?

Thank you in advance.

Labels (1)
6 Replies
Channa
Valued Contributor III

Re: Combining all bars into a single bar in a chart

remove the dimension from bar chart

just add static text in dimension ='AllAnimals' and use same mesure

Channa
user08192
New Contributor

Re: Combining all bars into a single bar in a chart

Thank you for that tip. That combined everything into a single bar, except that I actually have a second measure that I need to show. Let's call this "AllCarnivores" -- what I have now are two separate bars next to each other that both are gray and won't change to match the colors I set in the legend.

To add another level of complexity, I need these to be a stacked bar chart. I clicked on the 'bars' icon, just as I did in other graphs, but this time it isn't doing anything.

Any thoughts? Thanks!

Channa
Valued Contributor III

Re: Combining all bars into a single bar in a chart

do you have animal type herbivores, carnivore....??

then use type as dimension

Channa
user08192
New Contributor

Re: Combining all bars into a single bar in a chart

Hmmm... I guess it is pretty hard to describe my issue, or at least I'm doing a terrible job. I wish I could share my workbook or data, but I don't want to get fired 🙂

Let's say I have the same problem, but instead of having a single column that says herbivore/carnivore/omnivore, it has two separate columns: one that is "Eats meat" (yes/no) and one that is "Eats plants" (yes/no). And I want to show a stacked bar chart where animals that eat only meat are in red and animals that eat only plants or both are shown in green. And the bar height represents the number of animals. 

(And for the sake of keeping this in line with the data I have to use, I can't combine the columns into a single one.)

Sorry, I can't describe this better! Thanks for continue to try to help!

Channa
Valued Contributor III

Re: Combining all bars into a single bar in a chart

try this ur dimension

If(Eats meat='yes','type1'if(eatplants='yes',type2'))

 

possible share some sample data ...dosent need to be exact..similar data

Channa
user08192
New Contributor

Re: Combining all bars into a single bar in a chart

Thanks for the suggestion again. I'm still having no luck.

I'll see if I can find something to anonymize the data or else hand scrub the data tonight and re-post.