topic '*' after field name in expression in QlikView

'*' after field name in expression

Anonymous — Mon, 26 Sep 2016 09:14:06 GMT

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

Re: '*' after field name in expression

miguelbraga — Mon, 26 Sep 2016 09:26:05 GMT

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

Re: '*' after field name in expression

Anonymous — Mon, 26 Sep 2016 09:27:40 GMT

Hi,

This is the intersection.

See this post: Set Analysis: syntaxes, examples

Regards!

Re: '*' after field name in expression

tresB — Mon, 26 Sep 2016 09:42:51 GMT

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

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:42:52 GMT

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

Re: '*' after field name in expression

soloeeeoff — Mon, 26 Sep 2016 09:54:39 GMT

Hi Greeshma,

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

Thanks.

Re: '*' after field name in expression

Anonymous — Mon, 26 Sep 2016 16:42:18 GMT

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.

Re: '*' after field name in expression

Anonymous — Tue, 27 Sep 2016 03:23:19 GMT

Thanks everyone.