Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
thanks for the quick responds, but still the same error.
Give me sample application
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
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