topic Convert this expression into set expression in QlikView

Convert this expression into set expression

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

Below expression is for calculating previous month.

=date(AddMonths(date#(max([FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')

I want to calculate previous month based on date filter. It should not affected by any other selection like product name and rep id.

Bu using above normal exp. previous month calculation is changing as per selection like product name and rep id

tresB — Thu, 24 Aug 2017 11:06:13 GMT

Like this?

=date(AddMonths(date#(max( {<product, repid, anyotherfield>} [FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')

Note: If you want this to be unresponsive to any selection, you could just use {1}, like

date(AddMonths(max( {<1>} [FSPM Month Number]),-1),'YYYYMM')

Note: Here date#() is redundant (assuming your expression was a working one).

Clever_Anjos — Thu, 24 Aug 2017 11:06:46 GMT

Try this

Sum({1<[FSPM Month Number]={"$(=date(AddMonths(date#(max([FSPM Month Number]),'YYYYMM'),-1),'YYYYMM'))"}>} yourvaluefield)

Clever_Anjos — Thu, 24 Aug 2017 11:09:43 GMT