Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
I recommend you to read 4th Page from Attachment. So that, you will be star if you tried from yourself.
Hi Greeshma,
count({<[Quantity]*={">0"}>}order_date) is exactly similar to count({<[Quantity]=[Quantity]*{">0"}>}order_date)
Thanks.
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.
Thanks everyone.