Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can this "smartiebox" graph be done in QV?

Hi Everyone

I'd like to know if a graph like this is possible in QV? I have tried to replicate it and just can't seem to get it right. I started by using a straight table with Year and Asset class as dimensions. As an expression, I ranked the asset classes based on their yearly return. The closest I got to replicating the graph was selecting "horizontal" for the Year dimension under the presentation tab - however, this then makes everything horizontal and there ends up being multiple columns for the same year for each asset class. Please could someone let me know if they have any other ideas to do this? Any guidance would be much appreciated - thanks!

SmartieBox.jpg

1 Solution

Accepted Solutions
hector_munoz
Specialist
Specialist

yes... but is a very common solution in QlikView, and works fine

View solution in original post

6 Replies
neelamsaroha157
Specialist II
Specialist II

You can try block chart.

Anonymous
Not applicable
Author

I've tried that - does not give me what I'm looking for

hector_munoz
Specialist
Specialist

Try with a pivot table, one dimension as a row, one year dimension located as a expresion, all expanded, expresion with CRLF and colours in the background... I think it is possible!

hector_munoz
Specialist
Specialist

I think it is possible with only one year dimension as columns... Even row dimension could be avoided....

Anonymous
Not applicable
Author

Yeah I think I might have to strip the year dimension into columns. Was hoping to avoid this

hector_munoz
Specialist
Specialist

yes... but is a very common solution in QlikView, and works fine