topic Re: Set expression throwing error in QlikView

Set expression throwing error

Thu, 16 Oct 2014 05:09:21 GMT

Dear Friends,

Please help me out in this small issue -

I tried below expression in the expressions of straight table chart, but it gives error as Allocated memory exceeded.

Sum({<[TradeGroup] = {'Subscription'}>}[#NetAmount])

Thanks,

Deepti

Re: Set expression throwing error

SergeyMak — Thu, 16 Oct 2014 05:10:39 GMT

What are your dimensions?

Re: Set expression throwing error

jagan — Thu, 16 Oct 2014 05:12:21 GMT

Hi,

What is the size of your Dashboard?

What other dimensions and expressions in the chart?

Can you attach the sample file?

Try to recreate the chart and check.

Regards,

jagan.

Re: Set expression throwing error

vardhancse — Thu, 16 Oct 2014 05:15:18 GMT

Try lo delete all the temp from your desktop/laptop by using some CC cleaner and try now top open the dashboard.

Re: Set expression throwing error

Thu, 16 Oct 2014 05:30:54 GMT

That error can happen too when there's an error in an expression. Check your expressions for syntax errors. Or you simply added too many dimensions to a chart. If you add more than seven dimensions you should consider reducing that number, or using conditions to show/hide dimensions as needed, or creating a couple of simpler charts instead of just one big complicated one.

Re: Set expression throwing error

jonathandienst — Thu, 16 Oct 2014 05:42:03 GMT

I suspect that there is no proper association between the tables containing TradeGroup and #NetAmount - which is forcing Qv to do perform a cross join between them.

HTH

Jonathan

Re: Set expression throwing error

Thu, 16 Oct 2014 11:20:02 GMT

Thanku very very much everyone for replying. I appreciate each and everyone's help.

I solved this error by using below expression -

Sum(if(TradeGroup='Subscription',#NetAmount,0))

Although, I am still unclear why the set analysis expression failed and if clause worked. Is there any difference in processing the resultset in both these cases?

Thanks,

Deepti

Re: Set expression throwing error

jagan — Fri, 17 Oct 2014 01:52:05 GMT

Hi,

This is the best expression than using if, not sure why you are getting error

=Sum({<TradeGroup={'Subscription'}>}[#NetAmount])

Now you try giving this expression, hope this works now.

Regards,

Jagan.