topic Let statement as set statement in QlikView

Let statement as set statement

shahamel — Thu, 14 Feb 2013 14:56:42 GMT

Dear QV-users,

i would like to have the result of this formula as a set statement

RangeCount

(count(

{$<

LeerlingRecordId =

{"=

SUCCESVOL = '1'

"}

>}

DISTINCT LeerlingRecordId),BEKOSTIGD,OMVANG_OPLEIDING,Gecorrigeerde_Uitschrijving,KWALIFICATIE_NIVO,VERBINTENIS_NUMMER)

___

for example:

LET test = '

RangeCount

(count(

{$<

LeerlingRecordId =

{"=

SUCCESVOL = '1'

"}

>}

DISTINCT LeerlingRecordId),BEKOSTIGD,OMVANG_OPLEIDING,Gecorrigeerde_Uitschrijving,KWALIFICATIE_NIVO,VERBINTENIS_NUMMER)

SET test2 = test

When i use Set as expression i would like to see the result of the formula i use above.

Gr. Sandeep

Re: Let statement as set statement

manideep78 — Thu, 14 Feb 2013 15:27:27 GMT

Ofcourse you can use SET test2 = test;

Re: Let statement as set statement

shahamel — Fri, 15 Feb 2013 07:24:03 GMT

Unfortunately this is not what i ment. i will give you a more simple example of what i want

SCRIPT:

LET FORMULE = 7 + 1 ;

SET FORMULE2 = FORMULE

When i look at my settings - variables i would like to see at variable FORMULE2

NOT

FORMULE2 = FORMULE, but

FORMULE2= 8

when it comes to my real situation i don't want to see at settings - variables

TEST2 =

RangeCount(

count({$<LeerlingRecordId={"=SUCCESVOL='1'"}>} DISTINCT LeerlingRecordId)

,BEKOSTIGD,

OMVANG_OPLEIDING,

Gecorrigeerde_Uitschrijving,

KWALIFICATIE_NIVO,

VERBINTENIS_NUMMER) ;

BUT

TEST2 = 82

Gr. Sandeep

Re: Let statement as set statement

shahamel — Fri, 15 Feb 2013 07:24:13 GMT

Unfortunately this is not what i ment. i will give you a more simple example of what i want

SCRIPT:

LET FORMULE = 7 + 1 ;

SET FORMULE2 = FORMULE

When i look at my settings - variables i would like to see at variable FORMULE2

NOT

FORMULE2 = FORMULE, but

FORMULE2= 8

when it comes to my real situation i don't want to see at settings - variables

TEST2 =

RangeCount(

count({$<LeerlingRecordId={"=SUCCESVOL='1'"}>} DISTINCT LeerlingRecordId)

,BEKOSTIGD,

OMVANG_OPLEIDING,

Gecorrigeerde_Uitschrijving,

KWALIFICATIE_NIVO,

VERBINTENIS_NUMMER) ;

BUT

TEST2 = 82

Gr. Sandeep

Re: Let statement as set statement

manideep78 — Fri, 15 Feb 2013 07:58:23 GMT

Use this Statement


SET vFormula2 = $(vFormula);

See attached qvw,

Goto Settings--> Document Properties--> Variables.

U can see you variable as you like.

Re: Let statement as set statement

shahamel — Fri, 15 Feb 2013 09:02:13 GMT

This is my current script:

LOAD

* Inline [
test, naam
1,hoi
2,doei
];

SET onderdeel = {<test = {'hoi'}>};
LET vA= count($(onderdeel)test);
SET vB= $(vA);

WHen i run this i would expect to see at

setings --> document properties --> varables

vB = 1

but instead i get this

the script reload, but not succesfully

it says:

reload script failed. Reload old data?

Yes/No

if you know a way to make a variable like 'onderdeel' that works i am mostly gratefull.

Gr. sandeep

Re: Let statement as set statement

manideep78 — Fri, 15 Feb 2013 10:22:15 GMT

Set analysis donot work in the script part.

Re: Let statement as set statement

manideep78 — Fri, 15 Feb 2013 10:40:54 GMT

Still I didn't understood what you need. But little bit information i can give you, but what is the use of it?

Tab1:
LOAD *,If(naam='hoi',test) as Val;
LOAD * INLINE [
    test, naam
    1, hoi
    2, doei
];
LET vA =FieldValueCount('Val');
LET vB=$(vA);

Hope it helps you.