Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Evaluation of constructed variable

Hi everyone,

I am having an issue with the variable evaluation in a formula using a simple sum. I have two columns named A_text1 and A_text2 and a KPI that will be the sum(A_text1) or sum(A_text2) depending on a user choice of text1 or text2 through an extension variable. More specifically the user selects text1/text2 which is then stored in a variable called Selection so I construct the A_text1 through the expression: 'A_'&'$(Selection)' which gives me what i want. However, the formula is not working when using the sum('A_'&'$(Selection)').

Can anyone help me please?

1 Solution

Accepted Solutions

Re: Evaluation of constructed variable

Try this:

Sum($(='PLN_'&'$(Selection)'))

2 Replies

Re: Evaluation of constructed variable

Try this:

Sum($(='PLN_'&'$(Selection)'))

Not applicable

Re: Evaluation of constructed variable

I cannot thank you enough!!

Community Browser