Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
Just in case the expression did not format correctly I have atached this file with my expression
Add " around your variable
=sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype)>} amount)
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?
Now that you have seen my expression, how do I add a field from my TreeView (businessunit) current selection to this expression.
sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype),businessunit={"something"}>} amount)
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