Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT

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

vinieme12
Esteemed Contributor II

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

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



Attachments
Comments
Partner
Partner

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)

vinieme12
Esteemed Contributor II

I've attached Qvf file to the post now

brunobertels
Valued Contributor II

Hi

Very interesting , thanks for sharing QliKsense app example

Bruno

Seems very cool, thanks!

barnaby
New Contributor II

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.

0 Likes
rulohx87
New Contributor III

Nice Chart !

venkatasreekant
Valued Contributor

Very interesting, Thanks for posting!

Partner
Partner

Very interesting,

vinieme12
Esteemed Contributor II

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

BarCharts.JPG

Cheers

V

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2017-01-12 08:15 AM
Updated by: