topic Re: Boxchart Reporting Using Qlikview Objects in QlikView

Boxchart Reporting Using Qlikview Objects

Mon, 16 Dec 2013 16:54:27 GMT

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
Model	Year	1	2	3	4	5	6	7
xyz	2013	001	003	006	010	007	009
		002	004			008	010
			005				011

Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Mon, 16 Dec 2013 16:57:21 GMT

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

Re: Boxchart Reporting Using Qlikview Objects

Mon, 16 Dec 2013 17:00:43 GMT

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.

Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Mon, 16 Dec 2013 17:01:19 GMT

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

Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Mon, 16 Dec 2013 17:02:33 GMT

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.

Re: Boxchart Reporting Using Qlikview Objects

Mon, 16 Dec 2013 17:06:17 GMT

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

Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Mon, 16 Dec 2013 17:48:56 GMT

Can you post a .qvw?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Boxchart Reporting Using Qlikview Objects

Mon, 16 Dec 2013 19:41:07 GMT

Here is a sample qvw. Thanks!

Re: Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Mon, 16 Dec 2013 19:56:43 GMT

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...

Re: Boxchart Reporting Using Qlikview Objects

Mon, 16 Dec 2013 22:29:42 GMT

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.

Re: Boxchart Reporting Using Qlikview Objects

Wed, 18 Dec 2013 16:52:27 GMT

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?

Re: Boxchart Reporting Using Qlikview Objects

Nicole-Smith — Wed, 18 Dec 2013 16:56:34 GMT

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