Boxchart Reporting Using Qlikview Objects

[#1]

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-Smith]

You can use only() to get a text expression.

[#3]

I tried Only() but it gave me a value in the month only if there was one value.  So for the months that had more than one value it wouldn't display.  So I assume the only function was to find single values for a selection.

[Nicole-Smith]

Concat() will give you a list of values, if that is better.

[Nicole-Smith]

Actually, from what you're displaying up top, it seems like your data should be dimensions.  You can just put a dummy expression in, (e.g. =''), and then it will just seem like there isn't anything there, but it will show all of the dimensions.

[#6]

But will that give me the crosstab view I need for the months across the top?  I'm new at this tool.  Thanks!

[Nicole-Smith]

Can you post a .qvw?

Preparing examples for Upload - Reduction and Data Scrambling

[#8]

Here is a sample qvw.  Thanks!

[Nicole-Smith]

I see two options that you have for this data (see the attached--I would recommend Option 1).  If I'm missing anything, maybe someone else on the forum can chime in...

[#10]

Thanks, Nicole.  This is not exactly what they want to see but is an idea if I can't get anything else to work.  I'll see if anyone else has any ideas to make it work like they want to see it work.