Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anindya_manna
Contributor

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.

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

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.

1 Solution

Accepted Solutions
caio_caminoski
Contributor

Re: Convert this expression into set expression

Have you tried the following:

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


Of course you would have to change [rep id]  and [product name] for your field names.


Caio

4 Replies
MVP
MVP

Re: Convert this expression into set expression

I don't see any date field in the attached application?

caio_caminoski
Contributor

Re: Convert this expression into set expression

Have you tried the following:

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


Of course you would have to change [rep id]  and [product name] for your field names.


Caio

anindya_manna
Contributor

Re: Convert this expression into set expression

This one also working

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

anindya_manna
Contributor

Re: Convert this expression into set expression

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