Announcements
cancel
Showing results for
Did you mean:
Creator

current year calculation

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 ?

Labels (1)
• expression

1 Solution

Accepted Solutions
Specialist II

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' ?

6 Replies
Specialist II

Hi,

for your variable : equal before the expression :

vCurrent_Year=    =max(Policy_Financial_Year)

regards

Creator
Author

what ? i did not understand

Anonymous
Not applicable

Try on this way:

Policy_FINANCIAL_Year={ ' \$(vCurrent_Year) ' }

Specialist II

what do you have exactly in your variable ?

is there = sign ?

Anonymous
Not applicable

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.

Specialist II

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' ?

Tags