Set expression throwing error

[#1]

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

[SergeyMak]

Hi

What are your dimensions?

[jagan]

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.

[vardhancse]

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

[#5]

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.

[jonathandienst]

Hi

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

[#7 · Accepted solution]

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

[jagan]

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.