Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

greeshma_k
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
miguelbraga
Valued Contributor III

Re: '*' after field name in expression

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
Valued Contributor III

Re: '*' after field name in expression

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
Valued Contributor III

Re: '*' after field name in expression

Hi,

This is the intersection.

See this post: Set Analysis: syntaxes, examples

Regards!

MVP
MVP

Re: '*' after field name in expression

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.

Re: '*' after field name in expression

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)
Highlighted
soloeeeoff
New Contributor III

Re: '*' after field name in expression

Hi Greeshma,

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


5.PNG

Thanks.

mov
Esteemed Contributor III

Re: '*' after field name in expression

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
Contributor III

Re: '*' after field name in expression

Thanks everyone.