topic Re: Set Analysis is not working as expected in Qlik Learning Discussions

Set Analysis is not working as expected

alknirmal1 — Tue, 30 Sep 2014 20:39:31 GMT

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.

maxgro — Tue, 30 Sep 2014 20:54:38 GMT

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 — Tue, 30 Sep 2014 21:05:29 GMT

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 ?

maxgro — Tue, 30 Sep 2014 21:11:31 GMT

maybe with concat if you have many values

the set analysis reference manual

the set analysis reference post