topic Re. :Re: Integer variable in Qlikview in QlikView

Integer variable in Qlikview

Wed, 18 Aug 2010 15:00:54 GMT

Hi,

How can I declare an integer variable in my script Qlikview and use this variable in a text object.

Thanks.

Integer variable in Qlikview

villafuerte — Wed, 18 Aug 2010 15:18:04 GMT

SET X= 45;

LET X= 5*2; (this one will evaluate > 5*2=10)

Cheers

Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:29:02 GMT

Now, how to use this variable in a TEXT OBJECT.

Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:35:33 GMT

=myvariable

=$(myvariable)

Integer variable in Qlikview

Wed, 18 Aug 2010 16:36:21 GMT

Hi,

look at the example file.

I created a integer variable and a string variable.

The string ist then presented in a text box!

Cheers

Martin

Re. :Re: Integer variable in Qlikview

oscar_ortiz — Wed, 18 Aug 2010 16:38:30 GMT

In your script create your variable, something like this:

Let vText = 'Hello World';

In your Text Object create an expression to evaluate your variable:

=vText

Your Text Object should show "Hello World"

Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:41:50 GMT

I have done like this in my script:

LET nbMois = round((Date(DateFinExercice, $(DateFormat) )-Date(DateDebutExercice, $(DateFormat) ))/30);

and in the TEXT object, i have done

= nbMois and = $(nbMois) it did not work

Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:43:14 GMT

Please Martin, write your script in the message. My Qlikview version can't open your file.

I use Qlikview Personal Edition

Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:44:16 GMT

Oscar escuse me, i told of INTEGER Variable not Text Variable.

Re. :Re: Re. :Re: Integer variable in Qlikview

oscar_ortiz — Wed, 18 Aug 2010 16:53:44 GMT

Works the same way with integer:

Let vInteger = 45;

In your Text Object create an expression to evaluate your variable:

=vInteger

Your Text Object should show "45"

Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 16:59:21 GMT

Now, i have done like this,

LET nbMois = 45;
LET nbMois = round((Date(DateFinExercice, $(DateFormat) )-Date(DateDebutExercice, $(DateFormat) ))/30);

in text objet, i done:

= nbMois

but i have not a result

Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

oscar_ortiz — Wed, 18 Aug 2010 17:04:02 GMT

Your problem may lay in your formula:

Comment out your formula just to verify that placing a 45 in your variable will actually work for you.

LET nbMois = 45;
//LET nbMois = round((Date(DateFinExercice, $(DateFormat) )-Date(DateDebutExercice, $(DateFormat) ))/30);

If the 45 displays fine for you, you'll have to check your formula.

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 17:08:42 GMT

when i done as you, 45 displays fine.

Also, when i put this expression

= round((Date(DateFinExercice, $(DateFormat) )-Date(DateDebutExercice, $(DateFormat) ))/30);

in my text object, the good result displays 12

As i use this formula in many sheet, i would like to create a global variable.

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 17:22:16 GMT

Try this:

create a variable with your formula:

SET vFormula=round((Date(DateFinExercice, $(DateFormat) )-Date(DateDebutExercice, $(DateFormat) ))/30);

and use it later on like:

=$(vFormula)

Cheers

Martin

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 17:26:20 GMT

Thank you very much Martin

It works perfectly.

Can i have ur email adress.

This is mine : yimengael@yahoo.com

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Re. :Re: Integer variable in Qlikview

Wed, 18 Aug 2010 17:46:24 GMT

Hi,

can you please verify the answer?

THX.

Why do you need my E-Mail?

Martin