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: 
Not applicable

SET Brackets

For what and When do we use this brackets in SET Analysis,

( )

< >

[ ]

{ }

Thanks & Regards,

1 Solution

Accepted Solutions
Not applicable
Author

( ) = using for functions, Exp: Sum(Sales),Here Sum is function.

< >,{ } = using for expression.when u will start writting expression by using Set Analysis first {< exp> }

             Exp : {<Year={$(vMaxYear)}>}

[]   = Using for Field Name,If there is a gap between any FieldName,then u need to put field name in [ ]. Exp : [Product Code]

Exp of all brackets:

Sum({<Year={$(vMaxYear)}>},[Product Code]={AA001} Sales)

Regards-Bika

View solution in original post

4 Replies
Anonymous
Not applicable
Author

( )    not by themselves except in what is called dollar sign expansion

       - this is where you refer to a variable $(varName) or a formula $(=x+y)

< >  at the beginning and the end of the whole set, in the format {<....>}

[ ]   around field names when they have spaces in them, e.g. [Order Number]

{ }   at the beginning and the end of the whole set (see <> above). Also as the beginning and end of additional subsets

There are plenty of good references about set analysis that will explain this to you. See this post for a summary and some files. I would suggest looking at these and building knowledge from the ground up instead of trying to reverse engineer some existing code.

Jonathan

Not applicable
Author

simply

( ) use for define the Aggrigate function like sum(), Avg(), count() etc

< > use for define the modifiers that is inside it we write the condition

[ ] use for  define the field

{ } use for beginning and the end of the whole set analysis

Not applicable
Author

( ) = using for functions, Exp: Sum(Sales),Here Sum is function.

< >,{ } = using for expression.when u will start writting expression by using Set Analysis first {< exp> }

             Exp : {<Year={$(vMaxYear)}>}

[]   = Using for Field Name,If there is a gap between any FieldName,then u need to put field name in [ ]. Exp : [Product Code]

Exp of all brackets:

Sum({<Year={$(vMaxYear)}>},[Product Code]={AA001} Sales)

Regards-Bika

Not applicable
Author

Thanks Jonathan, viswaranjan, bika for the inputs...

if u have any more inputs related to SET or any helpfull application to train and build the logic please share with me, i tried reengineering but tht s providing me instant solution

but not enhancing my knowledge and understanding.