Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

Set Analysis Modifier is working for only 1 expression

Hi All,

I am using below expression for set analysis. By default it should show sum of Active count for both the sources('abc' and 'xyz') but it is working only for 'xyz' source and not for 'abc' . However when I select abc or xyz from list box it works perfectly.

sum({< activeinactivedate2= {'$(=max(activeinactivedate2))'},FinYearID= {'$(=max(FinYearID))'},Source = {'abc'}>} Active)+

sum({< activeinactivedate= {'$(=max(activeinactivedate))'},FinYearID= {'$(=max(FinYearID))'},Source = {'xyz'}>} Active)

I don't think so that there is issue in logic because it shows exact count after selecting the source from list box.

Please let me know where I am wrong.


1 Reply
Esteemed Contributor III

Re: Set Analysis Modifier is working for only 1 expression

May be this:

= RangeSum( sum({< activeinactivedate2= {"=$(= Date(max(activeinactivedate2), 'MM/DD/YYYY'))'}, FinYearID= { "= $(=max(FinYearID)) "}, Source = {'abc'} >} Active), 

sum({< activeinactivedate= { "=$(= Date(max(activeinactivedate), 'MM/DD/YYYY'))"}, FinYearID= {"= $(=max(FinYearID)) "}, Source = {'xyz'} >}  Active) )