Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ofcourse you can use SET test2 = test;
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
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
Use this Statement
SET vFormula2 = $(vFormula);
See attached qvw,
Goto Settings--> Document Properties--> Variables.
U can see you variable as you like.
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
Set analysis donot work in the script part.
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.