'*' after field name in expression

[Anonymous]

Hi All,

I have come across something similar to the below expression in my application and cannot understand the use of  '*' after a field name. Can someone help me understand this?

count({<[Quantity]*={">0"}>}order_date)

Regards,

Greeshma

[miguelbraga · Accepted solution]

Hey there,

In set Analysis the symbol '*' means an interception.

Check this post and document within it

Set Analysis: syntaxes, examples

Your expression:

=count({<[Quantity]*={">0"}>}order_date)

Means that the dimension Quantity must intersept with the values that are greater than zero. This is the condition in which you want to count the number of the order_date

Best regards,

D.A. MB

[Anonymous]

Hi,

This is the intersection.

See this post: Set Analysis: syntaxes, examples

Regards!

[tresesco]

count({<[Quantity]*={">0"}>}order_date) -this should ideally give you count of order_date where Quantity >0, as long as it is included in the current selection/scope. This is a bit different than count({<[Quantity]={">0"}>}order_date) - which results irrespective of selection (which may confuse the users).

Let me explain it a bit more. With expression having '*', if you select something that filters something like Quantity=10( i.e. <>0) , you would get 0 as output because your selection and the explicit set intersection is null. Whereas, without '*' in the set, with same selection you would get result for Quantity='>0'.

Or in other words, it is intersection of selection and explicit set ([Quantity]={">0"}).

Hope this helps.

[Anil_Babu_Samineni]

I recommend you to read 4th Page from Attachment. So that, you will be star if you tried from yourself.

[soloeeeoff]

Hi Greeshma,

count({<[Quantity]*={">0"}>}order_date)  is exactly similar to count({<[Quantity]=[Quantity]*{">0"}>}order_date)

Thanks.

[Anonymous]

I'd add that it is about selection in the Quantity field itself.  If selection is never made in this field, the '*' makes no difference in this expression.

[Anonymous]

Thanks everyone.