SET expression help!

[#1]

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

[amit_saini]

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

[arulsettu]

hi

$	:Represents the records of the current selection

[MK_QSL]

$ 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 = {''}

[arulsettu]

hi

check this link

Set Analysis in Qlikview and its components

[its_anandrjs]

Refer the reference manual or

Go through with this document in community

Romancing with Set Analysis

SET analysis guide

[#7]

Some expression i seen the " " double coatation will it is different or it is for another expression

[swuehl]

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