topic Re: SET expression help! in QlikView

SET expression help!

Fri, 18 Apr 2014 11:37:47 GMT

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

Re: SET expression help!

amit_saini — Fri, 18 Apr 2014 11:42:05 GMT

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

Re: SET expression help!

arulsettu — Fri, 18 Apr 2014 11:42:21 GMT

$	:Represents the records of the current selection

Re: SET expression help!

MK_QSL — Fri, 18 Apr 2014 11:42:31 GMT

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

Re: SET expression help!

arulsettu — Fri, 18 Apr 2014 11:43:16 GMT

check this link

Set Analysis in Qlikview and its components

Re: SET expression help!

its_anandrjs — Fri, 18 Apr 2014 11:43:44 GMT

Refer the reference manual or

Go through with this document in community

Romancing with Set Analysis

SET analysis guide

Re: SET expression help!

Fri, 18 Apr 2014 11:53:22 GMT

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

Re: SET expression help!

swuehl — Fri, 18 Apr 2014 12:00:09 GMT

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