topic append strings to create fieldname in QlikView

append strings to create fieldname

adityakesavkoll — Thu, 26 Apr 2012 06:52:10 GMT

I have columns like TOT_SLS_DLR, PUBLIC_SLS_DLR, PRIV_SLS_DLR,etc..

There is a list box which assigns the value 'TOT_' , 'PUBLIC_' and 'PRIV_' to a variable say v1.

I need to use something like sum($(v1)&'SLS_DLR') in my expression. How can we do this??

(assigning 'SLS_DLR' to another variable will not work in my case.)

Thanks in advance

-Aditya

Thu, 26 Apr 2012 06:57:35 GMT

you can try like this sum($(v1)) & 'SLS_DLR'

Regards,

P.Prasath

Thu, 26 Apr 2012 08:29:08 GMT

Hi Aditya:

Hope the attached App would help.

Thanks,

Narasimha K

adityakesavkoll — Thu, 26 Apr 2012 08:56:34 GMT

Thanks for the solution.

-Aditya

adityakesavkoll — Thu, 26 Apr 2012 12:03:15 GMT

Hi Narsimha

Is there a way to use the variablename or fieldname('=Type' in case of your qvw) in between two strings??

Ex. $(=Type&'_SLS_AMT') ->This is what we have used right now.

I need something like -> $('LCK_'&Type&'_SLS_AMT')

Thu, 26 Apr 2012 12:21:21 GMT

Hi Aditya:

See the attached QVW. Hope that helps.

I think you are missing an equl sign before left parenthesis, your expression should be - $(='LCK_'&Type&'_SLS_AMT')

Thanks,

Narasimha K