Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Visual tricks with charts. EQ-graph

cancel
Showing results for 
Search instead for 
Did you mean: 
Sergey_Shuklin
Specialist
Specialist

Visual tricks with charts. EQ-graph

Attachments

Hello, Everyone!

Today we gonna make this cute equalized graph:

p0.png

I call it "eq" because it similar with equalizer. Maybe it has a different name, no matter. Let's make it live!

Any data may be converted in rounded values:

p1.png

with this expression: round(sum(val)/$(=max(aggr(sum(val),mnt)))*10)

Next we can make a bar chart with calculated dimension ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

(if we want ten-pieces bars for each "mnt" field):

p2.png

As expression we should use: if(Mod(ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19),2)=0,0.1,1)

And have a background color for it like:

if(

mod(

ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

,2)=0,White(),

if(round(sum(val)/$(=max(aggr(sum(val),mnt)))*10)>

pick(

ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

,0,0,1,0,2,0,3,0,4,0,5,0,6,0,7,0,8,0,9)

,vGreen,White())

)

Note: Check Stacked on Style tab.

After that all we have to do is use some color and style variations:

p3.png

That's all! Hope you'll like it and if it so - share your opinion!

Thank you! !

Version history
Last update:
‎2017-10-13 05:56 AM
Updated by: