Skip to main content

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.

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

cancel
Showing results for 
Search instead for 
Did you mean: 
vinieme12
Champion III
Champion III

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

Attachments

Hi,

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

(link to thread: Qlikview Chart)

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


q.PNG

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

led.PNG

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

bands.PNG

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.

Singletone.PNG

HeatMap.PNG

Multi.PNG

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



Comments
sunny_talwar

Looks cool

migueldelval
Specialist
Specialist

Interesting, thank you vinieme12.

ahaahaaha
Partner - Master
Partner - Master

Very interesting, thank you.

vinieme12
Champion III
Champion III

Thanks Sunny

rwunderlich

Very cool. Thanks for posting.

richardouellett
Creator
Creator

Neat, Thank you!

robert_mika
Master III
Master III

Great stuff.

Thanks for sharing.

beck_bakytbek
Master
Master

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

Aurelien_Martinez
Partner - Specialist
Partner - Specialist

Hi,

That work

c61d1f31b0f942c48a33083b64a51ab1.png

beck_bakytbek
Master
Master

Hi Martinez,

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

thanks a lot

Version history
Last update:
‎2022-09-21 01:07 PM
Updated by: