Error in calculated dimension

[tenyeapen]

in a straight chart, in dimension I'm giving th ebelow expression in calculated dimension area and its giving the error Error in calculated Dimension.

if(Round(Today()-[Submitted To MCO Date])>3, count(INVOICE#),0)

please help me.

[Surya]

Hello., Try this if(Num(Today()) - Num([Submitted To MCO Date]) > 3, count([INVOICE#]),0)., In case of not working in Calculated Dimension Try the same in Expression and Drag where ever you want., I think Its Working

[tenyeapen]

thanks for the quick responds, but still the same error.

[Surya]

Give me sample application

[jonathandienst · Accepted solution]

I suspect that the problem is with the naked* field [Submitted To MCO Date] -- if there is more than one possible value in this context, then this will evaluate to null and the calculated dimension will fail. You may need to place this expression in an Aggr() function using suitable dimensions to ensure that there is only one possible value or use additional dimensions in your chart or table.

You can verify this by disabling the calculated dimension and temporarily adding the using the expression =[Submitted To MCO Date].

* a naked field is a field not enclosed with some sort of aggregation (like Sum(), Max(), etc

[Brett_Bleess]

Given the last post, I just wanted to add a Design Blog post that may be of some help as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833

If you are still working on things, please leave an update, if the last post got you what you needed, be sure to come back to the thread and use the Accept as Solution button to mark that as correct and to give credit for the help.  

Regards,
Brett