topic Re: current year calculation in App Development

current year calculation

capriconuser — Sat, 16 Nov 2024 07:59:07 GMT

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 — Tue, 10 Jul 2018 08:31:40 GMT

Hi,

for your variable : equal before the expression :

vCurrent_Year= =max(Policy_Financial_Year)

regards

capriconuser — Tue, 10 Jul 2018 08:53:00 GMT

what ? i did not understand

Anonymous — Tue, 10 Jul 2018 09:45:01 GMT

Try on this way:

Policy_FINANCIAL_Year={ ' $(vCurrent_Year) ' }

ogautier62 — Tue, 10 Jul 2018 09:56:30 GMT

what do you have exactly in your variable ?

is there = sign ?

Anonymous — Wed, 11 Jul 2018 10:24:41 GMT

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 — Thu, 12 Jul 2018 06:25:19 GMT

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