Sat Analysis Depth

[#1]

Hello,

How deep can sets be nested. I have an expression in a chart. I have the year, the months and the type.

=sum({year={$(=[vYearTwo]},Month={"*"},type=P(worktype)>}Amount)

[#2]

I am having trouble pasting my complete expression into this window.

I am not sure how to delineate the greater than/less than signs.

There shoud be approximately 70 characters in the following expression:

=sum({1<year={$(={vYearTwo}),month={"*"},worktype=P(worktype)>} amount)

[#3]

Just in case the expression did not format correctly I have atached this file with my expression

[Clever_Anjos]

Add " around your variable

=sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype)>} amount)

[#5]

Why shuold he use " ?

Why not ' ?

" is when you need it as a searchstring

' is when outcome is of type string

Im guessing his vYearTwo is a string?

[#6]

Now that you have seen my expression, how do I add a field from my TreeView (businessunit) current selection to this expression.

[Clever_Anjos · Accepted solution]

sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype),businessunit={"something"}>} amount)

[#8]

There are many docs on Set Analysis. I have published one doc several weeks ago that will answer to your current or folwing questions:

http://community.qlik.com/docs/DOC-4951

Fabrice