Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I need to under stand the SET expression if any one help me for this
Sum( {$< Date = {' $( =DATE(MAX(Date)))' }>} [Accno Count] )
what is mean for $ and ' ' cotation mark i am newbie
Thanks
Hi Emily,
For your knowledge in Set analysis:
0 - Represents an empty set
1 - Represents the full set of all the records in the application
$ - Represents the records of the current selection
$1 - Represents the previous selection
$_1 - Represents the next (forward) selection
Bookmark01 - Represents the bookmark ID or the bookmark name
Please see the attachment.
Thanks,
AS
hi
$ | :Represents the records of the current selection |
$ is like the expression is not static but dynamic... means any selection you make will be applicable for this epression
'' is used for covering $ expansion result....
liike if(Customer = 'Name'....
Here the result could be Date = {''}
Refer the reference manual or
Go through with this document in community
SET analysis guide
Some expression i seen the " " double coatation will it is different or it is for another expression
Sum( {$< Date = {' $( =DATE(MAX(Date)))' }>} [Accno Count] )
Here, the dollar sign in $(=DATE(MAX(Date))) has nothing to do with set analysis, it's a dollar sign expansion (see the HELP or this blog post for further explanations):
http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions