topic Re: Question of expression please help in QlikView

Question of expression please help

Anonymous — Thu, 05 Jun 2014 13:25:37 GMT

while creating a variable : if i define the variable as below the division is not working

$(Cy_NetRev)/$(Cy_NetUnits)

and if i define as below it is working.

$(Cy_NetRev)

$(Cy_NetUnits)

what is the difference between both of them and why one is working and another one not. Thanks for your help in advance

Re: Question of expression please help

Thu, 05 Jun 2014 13:35:23 GMT

I dont understand. I just tried creating a variable as $(Cy_NetRev)/$(Cy_NetUnits) and it is working fine.

I'm assuming that Cy_NetRev and Cy_NetUnits are variables as well. Please check the attachment and let me know what im missing.

Re: Question of expression please help

jonathandienst — Thu, 05 Jun 2014 13:35:33 GMT

Without the definition of those I am just guessing here. In your first example there is no delimiter between the / and the expanded variables. In the second there is. This is affecting the evaluation of the result.

HTH

Jonathan

Re: Re: Question of expression please help

Anonymous — Thu, 05 Jun 2014 14:13:18 GMT

Thanks for your reply Preethi & Jonathan. After doing some investigation i found that , see below screen shot.. Not sure if this is a general behavior of qlikview.