If statement for Month selection

[Karim_Khan]

Hi Team,

    I wanted to use If statement for Month selection  in expression.

Currently My calculation is working as below

=sum({$<FiscalMonth=>}[Net Bookings])

and expression

=AGGR(IF(Rank(sum([Net Bookings]), 4)<=5, [End Customer Global Ultimate Name]),[End Customer Global Ultimate Name])

When I click on Month then values gets associated from Fiscal Month

Month,Fiscal Month

Oct,3

Nov,4

Feb,7

Mar,8

But I want to Apply if condition so that If I will select the Month May then it should pick up the 3

May,3

Jun,4 and so on.

I want this dynamically.

Pls help me out

Regards,

KK

[gautik92]

try loading inline table

[Anonymous]

use mapping inline table together with applymap

TEST:

mapping load * Inline [

Month, Seq

May, 3

June, 4

...

];

in table

load

abc,

applymap('TEST',yourmonth) as SeqNr

def,

resident ...

[sasiparupudi1]

use the expression

FiscalMonth={"$(=date(addmonths(date#(Month,'MMM'),-2),'MMM'))"}

ex:date(addmonths(date#('May','MMM'),-2),'MMM')

[qlikviewwizard]

Can you please attach the sample file. It would be easier to provide the solution. Thank you.

[Karim_Khan]

But Sir will it work for dynamic month

[sasiparupudi1]

yes it should work if your fiscal month is always 2 months behind the actual month value

[Karim_Khan]

it is working.But If  I wanted to apply this login in Fiscal Month then.

It has the Numeric Value

1,2,3,4,....12.

Its code is as follows

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1

I wanted to apply the above logic to this

[Anonymous]

Hi Karim,

Try :

Pick(Match(MONTH,'May','Jun','Jul',........), 3,4,5,........)

Regards

Neetha

[sasiparupudi1]

what are the values in $(vFiscalYearStartMonth) ?