Simplifying the expression

[#1]

Hello

Is there a more simpler way of writing the expression.

if(

[AT Period End Date]>="$(=[Start Period])" and [AT Period End Date]<="$(=[End Period])",

aggr(sum(T_REV_UNAMORTZ),[Arrangement ID],[Invoice Number],[Invoice Line]),0

)

Do let me know because this way the expression renders for calculation for a lot of time.

Thanks

[petter]

You should have a look at the IntervalMatch() function. This can be used in your Load Script to get some value ( [AT Period End Date] ) that should fit within an interval ( [Start Period] ... [End Period] ) to match up. Then you can get rid of your costly IF. 

Whether you can simplify the Aggr() is harder to say since you haven't provided much detail about which dimensions you would use in your chart or anything about your data model.

[#3]

Hello

I am esentially trying to calculate the T_REV_UNAMORTZ within a given start

and end period. I cannot use it as an expression because of some

restriction which is why I have to write it as a calculated dimension.

I hope I have made myself clear.

Thanks

Riz

On Thu, Apr 2, 2015 at 4:02 PM, Petter Skjolden <qcwebmaster@qlikview.com>

[petter]

If you give us more context to how this expression is used with your data model - like give us some sample data or a sample load script or app - it would be much easier to help you.