Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

'*' after field name in expression

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

1 Solution

Accepted Solutions
miguelbraga
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

7 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

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
Not applicable
Author

Hi,

This is the intersection.

See this post: Set Analysis: syntaxes, examples

Regards!

tresesco
MVP
MVP

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.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soloeeeoff
Contributor III
Contributor III

Hi Greeshma,

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


5.PNG

Thanks.

Anonymous
Not applicable
Author

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
Not applicable
Author

Thanks everyone.