topic Re: Use of Calculated Dimension in Expression in App Development

Use of Calculated Dimension in Expression

Anonymous — Wed, 23 May 2018 12:03:41 GMT

Dear Qlik Community,

I would expect that the below Expression would return 58.072. Instead it takes the entire count of 63.338.

Count( {$<[PO creation time]={'a. same day'}>} [PurchDoc] )

I believe this is the result of the Calculated Dimension [PO creation time] which is used in the Expression.

Is there a way to handle this?

P.S. see attached print screens for more information.

Re: Use of Calculated Dimension in Expression

jonathandienst — Wed, 23 May 2018 12:19:35 GMT

Only physical field names can be used on the LHS of a set expression. So this expression will be ignored giving you the entire count. The simplest workaround is to use an If

=Count(If([PO creation time] = 'a. same day', PurchDoc))

Re: Use of Calculated Dimension in Expression

Anonymous — Wed, 23 May 2018 12:30:22 GMT

Hi Jonathan,

When using your expression an error pops up: Bad field name: [PO creation time].

Re: Use of Calculated Dimension in Expression

Anonymous — Wed, 23 May 2018 13:17:26 GMT

Hi Jonathan,

FYI. I've added a Sample file. This might be useful to play around with the Expression.

Re: Use of Calculated Dimension in Expression

tyember1 — Mon, 23 Sep 2019 21:45:05 GMT

Try adding a DISTINCT after the count.

Re: Use of Calculated Dimension in Expression

Saranyat — Tue, 24 Sep 2019 12:18:04 GMT

Hope this helps you thanks

=Count({ $<[C_PO creation time]={'<=0'}>} [PurchDoc] )