Error in calculation while using the logic in dimension

ashmitp869 — Tue, 31 Aug 2021 23:35:54 GMT

Hi there ,

I am using the if logic in dimension field -

=if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name)

but its giving me Error in calculated dimension.

Please assist.

My requirement is to show the report when (Interval(today()-max(daystart(Session_Start)),'D')) is greater than 90.

Thanks

Re: Error in calculation while using the logic in dimension

Kushal_Chawda — Tue, 31 Aug 2021 23:48:28 GMT

@ashmitp869 You need to use aggr function while using any aggregation function in dimension. You can use this expression in measure instead. If you still want to use it in dimension then try below

=aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name)

aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name,Session_Start)

Note: If there are other dimensions in your table, you need to include that as well in aggr function. check suppress null value option for this calculated dimension

topic Error in calculation while using the logic in dimension in QlikView

Error in calculation while using the logic in dimension

Re: Error in calculation while using the logic in dimension