Chart Representation

[#1]

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]

[#2]

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.

[#3]

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

[#4]

Any ideas guys?

[sathishkumar_go]

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

[#6]

@ Sathish

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

[#7]

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

[#8]

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]

[#9]

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.

[sathishkumar_go]

Hi Sravan,

Sorry i wrongly understand ur problem.

remove p_lastname in expression and use dimension only.

Regards

Sathish