Use of Calculated Dimension in Expression

[Anonymous]

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.

[jonathandienst]

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))

[Anonymous]

Hi Jonathan,

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

[Anonymous]

Hi Jonathan,

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

[tyember1]

Try adding a DISTINCT after the count. 

[Saranyat]

Hope this helps you thanks

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