topic Chart Representation in QlikView

Chart Representation

Thu, 15 Oct 2009 21:05:50 GMT

Hi Guys,

I am attaching this Example? I already posted and got this solution but it gives me " out of memory Problem". I think Qlikview multiplies the Dimension with each expression or something else and it gets stucks. The calculation time is increased from few seconds to a minute and my PC gets hanged. May be someone has any new ideas to get the same Display as in the attached Application.

Thanks

Sravan

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Example_2D00_Chart_5F00_Sravan.qvw]

Chart Representation

Thu, 15 Oct 2009 22:19:17 GMT

I'm not having problems with this example. But one thing you could do to help the situation is put "If(represent = above(represent), '', represent)" in the load script instead of in the chart. This might solve your issue.

Chart Representation

Fri, 16 Oct 2009 15:01:28 GMT

@ Anthony

Thanks for the response.

That was a Simple example but when I use it in My current Application, which I did not Post due to Security issues I get the "Out of Object memory" error. Actually I used what you said

"If(represent = above(represent,'',represent)" in the script. As "above" can be only used in an Expression, I changed it to Peek or Previous which does not have the same meaning. That did not help too..

Chart Representation

Wed, 21 Oct 2009 21:06:04 GMT

Any ideas guys?

Chart Representation

sathishkumar_go — Wed, 21 Oct 2009 21:31:04 GMT

Hi Sravan,

Check Synthetic keys in ur application. I am also facing this problem after that i ll reduce synthetic keys after working fine.

Check Circular loop also

Regards,

Sathish

Chart Representation

Wed, 21 Oct 2009 21:38:48 GMT

@ Sathish

I dont have any Synthetic keys. Anyway thanks for ur reply.

Chart Representation

Wed, 21 Oct 2009 21:53:09 GMT

For the Example which I attached above if u see in the sheet properties

Chart Representation

Wed, 21 Oct 2009 21:55:30 GMT

If I remove the Dimension and see the Properties it takes less than half of the memory. That is reason why I am getting in my Main application, which I could not post due to security reasons the Problem of "out of object memory"

in this example [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Example_2D00_Chart_5F00_Sravan1.qvw]

Chart Representation

Wed, 21 Oct 2009 22:01:14 GMT

I would be thankful, if anybody could suggest other ways of representing the Personal lastnames as in the first example. I need them in the right side of the chart as the customer wants it be displayed like that.

Chart Representation

sathishkumar_go — Wed, 21 Oct 2009 22:03:21 GMT

Hi Sravan,

Sorry i wrongly understand ur problem.

remove p_lastname in expression and use dimension only.

Regards

Sathish

Chart Representation

Wed, 21 Oct 2009 22:07:33 GMT

@ Sathish

That would have been easy but for the customer, he wants it to be displayed only at the right side. That is why I added it also like a Dimension and blindet it off to show it only in the Rightside in the expression. But if I do this this Memory problem is coming. Any other ideas to get it displayed on the rightside will be appreciated.

Chart Representation

Thu, 22 Oct 2009 16:47:34 GMT

Hi Sravan

Is there a good reason why you are using a Pivot Table for this?

I don't think there is any way to place a dimension on the right side of a pivot table, however, you can move a dimension to the right side when it is in the format of a straight table (just produce the table, then manually move the dimension to the right side).

I'm also not sure why including the last name as an expression would cause an object out of memory error, but on the other hand I'm not too surprised that it does this, expressions really should be used only for measures against dimensions.

Regards,

Chart Representation

Thu, 22 Oct 2009 18:51:07 GMT

Hi Nigel,

The only reason why I use Pivottable is that I have to have the Dimensions appearing only once as in the given example if there are corresponding many Workers in the righthand side. It can be done only with a pivot table. when I use the straighttable, I get a entry corresponding to every worker. They have to grouped together if they are having the Same Organisation as in the Example.

Thanks for the reply

Sravan