topic Re: how to create a variable? in how many ways it is possible? in QlikView

how to create a variable? in how many ways it is possible?

Thu, 21 Nov 2013 05:27:28 GMT

Hi,

i am new to qlikview. ans me please..

khadeer

Re: how to create a variable? in how many ways it is possible?

israrkhan — Thu, 21 Nov 2013 05:33:47 GMT

there are many ways to create Variable, in script and in front end.

1) you can create it in script, Like Let a = 10. a is a variable having value 10.

2) you can create in document properties, sheet properties, there you will see variables , just click create new variable and give it a name.. and you can also create while creating new Calendar, Slider, if you right click on sheet>> and go to new object>> select Calendar/Slider. Here you will see new variable button as well..

Hope it Helps

Re: how to create a variable? in how many ways it is possible?

Thu, 21 Nov 2013 05:37:24 GMT

Hi Khadeer,

Check out this Attachement you will get the clear whole idea of What Variable is and How to use it.

hope it helps you

regards,

ravikant

Re: how to create a variable? in how many ways it is possible?

Nagaraju_KCS — Thu, 21 Nov 2013 05:47:44 GMT

In scripting level 2 types.

LET and SET

SET: adding the string value to a variable

SET vResult='2+5'

returns 2+5

LEt: adding the expression result to a variable.

LET vResult=2+3

returns 5

Hope it Helps.....

Re: how to create a variable? in how many ways it is possible?

er_mohit — Thu, 21 Nov 2013 05:56:11 GMT

See the Below Script

LOAD * INLINE [

item, rate

coe, 0.23

cog, 0.50

];

LOAD *

Resident A ;

LET vrate=Peek('rate',-1,'A');

here by default in edit script there is some variable with predefined save using Set command

you can see all the global variables under setting -->User Prefrence--->general

check on show system variable

ok and see the all variables

in Script side use set and let variable

set vDate= 10-10-2013 ;

let sum = 4+ 5 ;

reload it

and in sheet object side

take text object

write

=vDate

then it gives Date because it works like string stateent

if write

=sum then it evaluate the answer is 9 in let statement on script side

but on dashboard side

you also make variable

press ctrl+alt+v

add variable

new

below write 4+5

then ok

in text object when write =new then it gives 4+5 works as a string

if again makes variable

new1

write

=4+5

use it in text obj

write

=new1

then gives 9 works as let statement

hope it helps

Re: how to create a variable? in how many ways it is possible?

Sun, 01 Dec 2013 02:07:31 GMT

Hi Ravikanth,

I tried to download attachment at many times,it is not opening file, can you please send me the pdf again.

Thanks

Khadeer

Re: Re: how to create a variable? in how many ways it is possible?

Mon, 02 Dec 2013 05:44:44 GMT

hi,

check if it opens,

Regards,

Ravikant