topic Re: Error in calculated dimension in QlikView

Error in calculated dimension

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Error in calculated dimension

Surya — Tue, 05 Nov 2019 05:05:05 GMT

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

Re: Error in calculated dimension

tenyeapen — Tue, 05 Nov 2019 05:34:50 GMT

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

Re: Error in calculated dimension

Surya — Tue, 05 Nov 2019 05:44:46 GMT

Give me sample application

Re: Error in calculated dimension

jonathandienst — Tue, 05 Nov 2019 05:50:41 GMT

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

Re: Error in calculated dimension

Brett_Bleess — Mon, 11 Nov 2019 14:58:54 GMT

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