current year calculation

[capriconuser]

Hi all

i want to calculate current year calculation on qlik sense and i try this but this is not working

'This yr: '({<Policy_FINANCIAL_Year={$(vCurrent_Year)},Policy_FINANCIAL_Month=,Policy_FINANCIAL_Quarter= >})

&Num($(Claim_OS)/pow(1000,floor(log10(fabs($(Claim_OS)))/3)),'#,##0.0')

& pick(floor(log10(fabs($(Claim_OS)))/3)+1,'',' K',' MN',' BN',' TN')

here vCurrent_Year= max(Policy_Financial_Year)

any solution ?

[ogautier62]

Hi,

for your variable : equal before the expression :

vCurrent_Year=    =max(Policy_Financial_Year)

regards

[capriconuser]

what ? i did not understand

[Anonymous]

Try on this way:

Policy_FINANCIAL_Year={ ' $(vCurrent_Year) ' }

[ogautier62]

what do you have exactly in your variable ?

is there = sign ?

[Anonymous]

there are two ways as I know:

1) you need put '=' as first simbol in your variable, and just put construction $(vCurrent_Year) to SA

2) Use this  construction in SA:

  Policy_FINANCIAL_Year={ ' $(vCurrent_Year) ' },

to put text result from your variable.

Please correct me if I am wrong.

[ogautier62 · Accepted solution]

for me it's 1) and 2)

define v as : (with = before)

vCurrent_Year=    =max(Policy_Financial_Year)

then set expression is ok

did you try 'Capricon user' ?