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: 
arethaking
Creator II
Creator II

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Hi Guys,

What is the meaning of this set expression?

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Thanks in advance.

1 Solution

Accepted Solutions
migueldelval
Specialist
Specialist

Hi Aretha,

Sum Sales when your field ingredients contens garlic and other text.

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Sum(Sales )---> Principal expression


{$<~Ingredient = {“*garlic*”}>}  ----> Set Analysis: Limit your principal expression with a condition

$ ----> All your filters affect your expression

"..." ---> Use to find somthing

*...* ---> It makes that find all words that contens garlic

Regards

Miguel del Valle

View solution in original post

7 Replies
migueldelval
Specialist
Specialist

Hi Aretha,

Sum Sales when your field ingredients contens garlic and other text.

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Sum(Sales )---> Principal expression


{$<~Ingredient = {“*garlic*”}>}  ----> Set Analysis: Limit your principal expression with a condition

$ ----> All your filters affect your expression

"..." ---> Use to find somthing

*...* ---> It makes that find all words that contens garlic

Regards

Miguel del Valle

arethaking
Creator II
Creator II
Author

What is "~" in the expression?

Frank_Hartmann
Master II
Master II

sum( {$<~Ingredient = {"*garlic*"}>} Sales )

returns the sales for current selection, but with a forced exclusion of all Ingredients containing the string 'garlic'

Not applicable

hi arethaking

In this below expression you using ~ symbol before the field.


It will exclude the values which consists of garlic.


Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Frank_Hartmann
Master II
Master II

If you want to force exclusion of specific field values, you will need to use "~" in front of the field name

amit_saini
Master III
Master III

Hi,

Please see the attachment to understand Set Analysis expressions.

Thanks,
AS

migueldelval
Specialist
Specialist

Sorry Arteha,

I didn´t see this, it exclude the condition.

Finally:

Sum Sales when your field ingredients haven´t garlic in your field ingredients.



Try this document, it´s so useful.


Set Analysis: syntaxes, examples



Regards


Miguel del Valle