topic Re: SET Brackets in QlikView

SET Brackets

Tue, 18 Jun 2013 11:57:01 GMT

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

( )

< >

[ ]

{ }

Thanks & Regards,

Re: SET Brackets

Anonymous — Tue, 18 Jun 2013 12:07:48 GMT

( ) 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

Re: SET Brackets

Tue, 18 Jun 2013 12:17:55 GMT

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

Re: SET Brackets

Tue, 18 Jun 2013 12:25:46 GMT

( ) = 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

Re: SET Brackets

Wed, 19 Jun 2013 04:59:48 GMT

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.