Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
amyami187
New Contributor

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

Tags (1)
1 Solution

Accepted Solutions
hector_munoz
Valued Contributor

Re: Can this "smartiebox" graph be done in QV?

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

6 Replies
neelamsaroha157
Valued Contributor II

Re: Can this "smartiebox" graph be done in QV?

You can try block chart.

amyami187
New Contributor

Re: Can this "smartiebox" graph be done in QV?

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

hector_munoz
Valued Contributor

Re: Can this "smartiebox" graph be done in QV?

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
Valued Contributor

Re: Can this "smartiebox" graph be done in QV?

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

amyami187
New Contributor

Re: Can this "smartiebox" graph be done in QV?

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

hector_munoz
Valued Contributor

Re: Can this "smartiebox" graph be done in QV?

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