Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Convert this expression into set expression

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Convert this expression into set expression

sorry

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

13 Replies
Partner
Partner

Re: Convert this expression into set expression

try using this expression:

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

Re: Convert this expression into set expression

Can be simplified to this

=Date(AddMonths(Max({1} [FSPM Month Number]), -1),'YYYYMM')

Partner
Partner

Re: Convert this expression into set expression

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

Partner
Partner

Re: Convert this expression into set expression

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

Partner
Partner

Re: Convert this expression into set expression

I want to date selection will change the calculation but not rep id or product name field.

if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.

Re: Convert this expression into set expression

May be this

=Date(AddMonths(Max({1<[FSPM Month Number] = p([FSPM Month Number])>} [FSPM Month Number]), -1),'YYYYMM')

Partner
Partner

Re: Convert this expression into set expression

try using this expression:

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

Partner
Partner

Re: Convert this expression into set expression

Its not working.

it displaying 245203.Also  date selection not affecting the result

Re: Convert this expression into set expression

Would you be able to share a sample to look at this?