Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
greeshma_k
Creator III
Creator III

'*' 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
Specialist III
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
Specialist III
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

manucamon
Specialist III
Specialist III

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.

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.

mov
Champion III
Champion III

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.

greeshma_k
Creator III
Creator III
Author

Thanks everyone.