topic Re: How to Merge 2 Variables in QlikView

How to Merge 2 Variables

priyarane — Wed, 28 Oct 2015 10:01:50 GMT

Hi Community,

I wanted to merge 2 variables like below.

=$(vExp_ACCR_INCOME_DRAWN) / $(vDenominationValue)

I have tried like below

=$(vExp_ACCR_INCOME_DRAWN) $(=chr47)) & $(vDenominationValue)

but not worked out.

How to do '/'

MK_QSL — Wed, 28 Oct 2015 10:03:22 GMT

Isn't this working ?

Variable1 & '/' & Variable2

priyarane — Wed, 28 Oct 2015 10:07:34 GMT

amit_saini — Wed, 28 Oct 2015 10:08:58 GMT

Check

Thanks,
AS

mpbtejada — Wed, 28 Oct 2015 10:10:23 GMT

Are you intending to return a text value or to compute a formula?

If you want text, encapsulate the variables in single quotes.

'$(vExp_ACCR_INCOME_DRAWN)' & '/' & '$(vDenominationValue)'

amit_saini — Wed, 28 Oct 2015 10:12:46 GMT

Try,

=($(vExp_ACCR_INCOME_DRAWN) ) / ($(vDenominationValue) )

I think brackets are missing.

Thanks,AS

amit_saini — Wed, 28 Oct 2015 10:13:53 GMT

This should work:

num(

($(vExp_ACCR_INCOME_DRAWN) ) / ($(vDenominationValue) )

,'###.###,')

Thanks,
AS