article Bar or Equalizer ! - A different Bar Chart for your viewing pleasure in Member Articles

Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

vinieme12 — Wed, 21 Sep 2022 17:07:35 GMT

Hi,

The Following blog was inspired by a recent post that allowed me to exercise my brain into trying something new

Below is one of the two charts to be achieved in Qlikview. This led / music equalizer style looked pretty cool so I had to try

I finished with a chart like this. Close enough I'd say.

You can also adjust the number of bands you wish to see on the chart, but make sure you adjust the percentage scales for background colors

How did we achieve this chart?

The Idea is to break each value into multiple segments and then use background expression to make only alternate segments visible.

Simple isn't it.

So we've basically turned a simple single dimension one expression chart into a Stacked Chart with two Dimensions and one Expression.

Apply the same approach with Grid Charts which allow other visualization possibilities.

These are just for your viewing pleasure, hope you enjoy playing with them as much as I did.

Happy Qlik'in

Cheers

Vineeth

‌

Vineeth Pujari

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

sunny_talwar — Thu, 12 Jan 2017 13:25:02 GMT

Looks cool

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

migueldelval — Thu, 12 Jan 2017 13:43:34 GMT

Interesting, thank you vinieme12.

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

ahaahaaha — Thu, 12 Jan 2017 13:53:01 GMT

Very interesting, thank you.

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

vinieme12 — Thu, 12 Jan 2017 16:53:52 GMT

Thanks Sunny

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

rwunderlich — Thu, 12 Jan 2017 17:25:27 GMT

Very cool. Thanks for posting.

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

richardouellett — Thu, 12 Jan 2017 21:52:07 GMT

Neat, Thank you!

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

robert_mika — Fri, 13 Jan 2017 11:26:38 GMT

Great stuff.

Thanks for sharing.

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

beck_bakytbek — Mon, 16 Jan 2017 13:49:38 GMT

Hi Pujari,

it does look great, my question is, is that possible in Qlik Sense?, if yes, can you create such example in Qlik Sense

thanks in advance for your responce

beck

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

Aurelien_Martinez — Mon, 16 Jan 2017 13:54:58 GMT

Hi,

That work

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

beck_bakytbek — Mon, 16 Jan 2017 14:03:13 GMT

Hi Martinez,

thanks a lot for your response, could do you post your example

thanks a lot

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

Aurelien_Martinez — Mon, 16 Jan 2017 17:21:45 GMT

I have used the default script (ctr + 00) and this expression :

If(DIM <= round(Sum(Expression1)/Max(TOTAL Aggr(Sum(Expression1), Dim1))*40),

Sum(Expression1)/round(Sum(Expression1)/Max(TOTAL Aggr(Sum(Expression1), Dim1))*40)

)

Color by expression :

if(even(RowNo())=0,argb(0,255,255,255),

if(DIM >= 40*.90 ,rgb(196, 77, 88),

if(DIM >= 40*.70 ,rgb(255, 107, 107),

if(DIM >= 40*.50 ,rgb(252, 157, 154),

if(DIM >= 40*.30 ,rgb(249, 205, 173),

if(DIM >= 40*.20 ,rgb(0, 180, 204),

if(DIM >= 40*.05 ,rgb(13, 103, 89),

)))))))

(replace 40 by a variable if you what)

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

vinieme12 — Mon, 16 Jan 2017 20:24:49 GMT

I've attached Qvf file to the post now

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

brunobertels — Tue, 17 Jan 2017 12:40:07 GMT

Very interesting , thanks for sharing QliKsense app example

Bruno

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

julian_rodriguez — Wed, 18 Jan 2017 13:33:37 GMT

Seems very cool, thanks!

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

barnaby — Sun, 22 Jan 2017 23:14:51 GMT

G'day Vineeth,

The main example in your post looks nice and neat, clear and informative. Not much redundant 'ink' on the page. However, your 'Grid Chart' examples look very busy and would distract the viewer from the information that you're trying to convey.

Cheers,

Barnaby.

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

rulohx87 — Tue, 24 Jan 2017 21:23:52 GMT

Nice Chart !

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

Anonymous — Wed, 25 Jan 2017 04:21:10 GMT

Very interesting, Thanks for posting!

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

mario_sergio_ti — Wed, 25 Jan 2017 15:49:28 GMT

Very interesting,

Re: Bar or Equalizer ! - A different Bar Chart for your viewing pleasure

vinieme12 — Sun, 05 Feb 2017 08:20:11 GMT

Hi barnaby

I've shown a trick; how you apply it is up to you.

In the post I have shown heat maps, you could also use it to show fill to value charts

Cheers