Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

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
Highlighted
Specialist
Specialist

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

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

Highlighted
Creator II
Creator II

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

What is "~" in the expression?

Highlighted
Master II
Master II

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

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

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

Highlighted
Not applicable

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

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 )

Highlighted
Master II
Master II

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

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

Highlighted
Master III
Master III

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

Hi,

Please see the attachment to understand Set Analysis expressions.

Thanks,
AS

Highlighted
Specialist
Specialist

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

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