topic Re: Set analysis expression in QlikView

Set analysis expression

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

I have the below expression and it doesn't work.Any help is appreciated.

=sum({<[Expense Month-Year]={'$(>=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

[Subspace Commence]={'$(< addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

Thank you very much.

Re: Set analysis expression

Chanty4u — Thu, 06 Jul 2017 13:35:02 GMT

try this

=sum({<[Expense Month-Year]={'>=$(=MonthName(Today())& <= monthname(AddMonths(today() ,11))'},

[Subspace Commence]={'<$(= addmonths(today(),12,'MM/DD/YYYY'))'}>}Finalamount)

Re: Set analysis expression

sunny_talwar — Thu, 06 Jul 2017 13:35:13 GMT

Incorrect syntax, try this:

=Sum({<[Expense Month-Year] = {"$(='>=' & MonthName(Today()) & '<=' & MonthName(AddMonths(Today(),11)))"}, [Subspace Commence] = {"$(='<' & Date(AddMonths(Today(), 12), 'MM/DD/YYYY'))"}>} Finalamount)

Not sure if this will work, but the syntax should be better with the above expression

Re: Set analysis expression

Anil_Babu_Samineni — Thu, 06 Jul 2017 13:36:25 GMT

Try this?