topic Re: Variable in QlikView

Variable

Anonymous — Mon, 23 Jun 2014 10:46:34 GMT

I want to show a variable in a text box divided by 1000

I have put =$(vVariable)/1000 but it doesn't work. Please help

Thanks

Re: Variable

nilesh_gangurde — Mon, 23 Jun 2014 10:48:15 GMT

Use this :

='$(vVariable)'/1000

Re: Variable

vardhancse — Mon, 23 Jun 2014 10:49:43 GMT

For text object not required $ symbol.

Please try =(vVariable)/1000

Re: Variable

ashfaq_haseeb — Mon, 23 Jun 2014 10:50:03 GMT

Hi,

Its working as expected.

What is the definition of vVariable

Regards

ASHFAQ

Re: Variable

Anonymous — Mon, 23 Jun 2014 10:53:25 GMT

Sorry, this doesn't work

Re: Variable

Anonymous — Mon, 23 Jun 2014 10:53:32 GMT

Sorry, this doesn't work

Re: Variable

tresB — Mon, 23 Jun 2014 10:53:53 GMT

If you are defining your variable with an expression like: Sum(....) or so, you might have to add an '=' symbol prior to your definition like: =Sum(...)

Re: Variable

Anonymous — Mon, 23 Jun 2014 10:55:09 GMT

I have no issue with the variable calculation. That works as expected. If vVariable has a value of 10,000 I want to show 10 in the text box but when I use the above expression it still shows 10,000

Re: Variable

vardhancse — Mon, 23 Jun 2014 10:55:29 GMT

can u please tell the variable name.

for eg i have created one variable called vSum

if i want to display the value in the list box:

i can enter as =(vSum)/1000

It will work

Re: Variable

Anonymous — Mon, 23 Jun 2014 10:57:09 GMT

I have no issue with the variable calculation. That works as expected. If vVariable has a value of 10,000 I want to show 10 in the text box but when I use the above expression it still shows 10,000

Re: Re: Variable

ashfaq_haseeb — Mon, 23 Jun 2014 10:57:43 GMT

Hi,

Look at the attached application.

Regards

ASHFAQ

Re: Variable

vardhancse — Mon, 23 Jun 2014 11:07:34 GMT

can you please send the sample QVW file,so that we can able to see.

I have tried and getting correct value.

Re: Variable

Mon, 23 Jun 2014 11:12:36 GMT

Can you give screen shot of you variable

Thanks

Padma

Re: Variable

Anonymous — Mon, 23 Jun 2014 11:12:46 GMT

Weird, because it works on your app. I have now used

=sum(vVariable)/1000

which seems to work. Not sure why I don't get the same result as you as you have done the identical to my original expression.

Thanks anyway