Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a boxchart with serial numbers listed below the months for the current year by model. I can't seem to get a chart to display just text information that is not a numeric expression. Please advise.
Here is an example using a table but can't figure out how to get the same in Qlikview.
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 | Header 9 | Header 10 | Header 11 |
---|---|---|---|---|---|---|---|---|---|---|
Model | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
xyz | 2013 | 001 | 003 | 006 | 010 | 007 | 009 | |||
002 | 004 | 008 | 010 | |||||||
005 | 011 |
Nicole,
Thanks, I did just make a change on the concat and used the Char(10) carriage line feed character instead of a comma to separate so that they would show in what appears to be separate lines and that is much closer. But is there anyway to dynamically change the height of the box so it fits the values instead of hardcoding. I used the Presentation property of Wrap Cell Text but then I have to hard code the cell height which I won't always know. Any thoughts on how to make that work?
QlikView doesn't allow us to set the height dynamically, so I think you're out of luck on that one.
There are some ideas out there for it though that you can vote up: http://community.qlik.com/ideas/2937