Set Analysis Modifier is working for only 1 expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks

Re: Set Analysis Modifier is working for only 1 expression

vishsaggi — Mon, 03 Jul 2017 15:46:52 GMT

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) )

topic Set Analysis Modifier is working for only 1 expression in QlikView

Set Analysis Modifier is working for only 1 expression

Re: Set Analysis Modifier is working for only 1 expression