topic Re: passing variable to a variable in QlikView

passing variable to a variable

gerrycastellino — Mon, 12 Oct 2015 04:39:32 GMT

I have 2 variables defined,

vNumDisplay=

if(Sum($1)/1000000 >= 1, Num((Round(Sum($1)/1000000,.1))) & 'M',

if(Sum($1)/100000 >= 1, Num((Round(Sum($1)/1000,.1))) & 'K', Sum($1)/1000))

vES=< result of some number>

how do I structure the syntax to pass vES into vNumDisplay in a text box ?

$(vNumDisplay$(vES))

$(vNumDisplay$(=vES))

- all above do not work ???

Re: passing variable to a variable

petter — Mon, 12 Oct 2015 04:43:37 GMT

Remove the second dollar-sign:

$(vNumDisplay(vES))

Re: passing variable to a variable

gerrycastellino — Mon, 12 Oct 2015 05:29:11 GMT

did not work ...

Re: passing variable to a variable

gerrycastellino — Mon, 12 Oct 2015 05:31:09 GMT

this did:

=$(vNumDisplay($(=$(vES))))

Re: passing variable to a variable

jonathandienst — Mon, 12 Oct 2015 05:32:10 GMT

I think you need the $ sign, but like this (at least that is how I have always done it):

$(vNumDisplay($(vES)))

But in this case, when vES is expanded into the expression in vNumDisplay, it must make legal and semantic sense in a Sum(). I don't think a value is expected here.

Re: passing variable to a variable

petter — Mon, 12 Oct 2015 06:49:53 GMT

Actually it worked very well for me - in the context I used it. So probably you used it in another context where it didnt work. But that is how the harder to understand parts of QlikView often works - it is very context sensitive...