Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

alknirmal1
New Contributor III

Set Analysis is not working as expected


Hi All,

Actually i am writing a set analysis to filter the entire data based on a particular date.

Expression used : 
=

sum({1<AsOfDate={"=$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

Here I am summing up the BookValue_Acct for a particular date 2014-09-15.

This expression doesnt give the correct result..But if I am making the '=' to  '<=' or '>=' , then its working perfectly fine.

Can anybody please advise me on this ?

2) if I have a list box which contains the dates.. If I want to pass the selected value from list box to this set analysis

expression , how can i do that ? i tried giving in different ways .but always it gives the syntax error.

Thanks

Nirmal.

3 Replies
MVP
MVP

Re: Set Analysis is not working as expected

try to remove bold =

sum({1<AsOfDate={"=$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)


sum({1<AsOfDate={"$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

alknirmal1
New Contributor III

Re: Set Analysis is not working as expected

Thanks a lot for your quick reply.. It works fine !!

Will you be able to help on to pass a list box selected field in the same expression ?

MVP
MVP

Re: Set Analysis is not working as expected

maybe with concat if you have many values

Re: Data islands and set analysis

the set analysis reference manual

Set Analysis: syntaxes, examples

the set analysis reference post

Re: Re: Components Of Set Analysis

Community Browser