Calculated Dimension

[#1]

I want to create last three month data based on selected month

[amit_saini]

Hi,

Try something like below:

<Month = {"$(=max({$} Month)-2)"}>

<Month = {"$(=max(Month)-2)"}> , {$} = current selection, it is the default

Thanks,
AS

[amit_saini]

Also check this:

http://community.qlik.com/message/463894#463894

Thanks,
AS

[#4]

hope attached file helps you

[avinashelite]

Hi

Find the solution below:

use like this : =if(SHIP_MONTH<=APPAC_SelectedMonth and SHIP_MONTH>=APPAC_SelectedMonth-3,SHIP_MONTH) in dimension

[#6]

Hi Bhawna Gupta

i am not expecting this based on selected current month i should display selected month-1 and -2 in

Calculated Dimension 

in expression i have another values

[#7]

so in dimension itself you use this like

if(Month<=Max(Month) and Month>Max(Month)-3,Month)

[avinashelite]

Hi siva,

Did you check my attachment and calculated dimension which i have given in the previous post.

[#9]

in calculated dimension use following expression

=if(match(Month,'$(=Max(Month))','$(=Max(Month)-1)','$(=max(Month)-2)'),Month)

and click ok and after that check suppress null value option in the same tab

hope above option will work for you

[#10]

no need of max month dear

understand my problem on based on current selection of month in input box i need to change in chat i want to get -3 values

if i select 12 month i want to get nov oct sep data

i have two expression