topic Re: Issue with the sub in App Development

Issue with the sub

fawazqutami — Thu, 20 Jul 2017 02:41:51 GMT

Dears,

I'm trying to load the below script but I've got a message 'Field 'VST_ID' not found'!

why is that? please help ..................

Thank you

Sub TPP_ROOT (VST_ID)

VST_SUMM:

LOAD

Sum(SPAYER) as GUEST,

Sum(CSHARE) as PAYER

FROM C_REV where IH_EMR_VST_ID_MAS=VST_ID Group By IH_EMR_VST_ID_MAS;

Store VST_ID,PAYER, GUEST from VST_SUMM into TPP_SUM;

Drop Table VST_SUMM;

EndSub

Sub TPP_VST (VST_ID))

VST_SUMM:

LOAD

Sum(SPAYER) as GUEST,

Sum(CSHARE) as PAYER

FROM C_REV

(qvd) where IH_EMR_VST_ID=VST_ID Group By IH_EMR_VST_ID;

Store VST_ID,PAYER, GUEST from VST_SUMM into TPP_SUM;

Drop Table VST_SUMM;

EndSub

//------------------------------------------------

OPV: LOAD*FROM OPV_Table

For A=1 to NoOfRows('OPV')

if NOTE_TYPE=0 then

Call TPP_ROOT(IH_EMR_VST_ID);

elseif NOTE_TYPE<>0 then

Call TPP_VST(IH_EMR_VST_ID);

Next A

Re: Issue with the sub

rwunderlich — Thu, 20 Jul 2017 04:55:09 GMT

Both of your STORE statements reference the the field "VST_ID". However, VST_ID is not created in the LOAD statement. It may be simpler if you did not reference any fields in your STORE statement. e.g.

STORE VST_SUMM into TPP_SUM;

Also, it's conventional to use the .qvd extension on the STORE filename. e.g.

STORE VST_SUMM into TPP_SUM.qvd;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Issue with the sub

tomasz_tru — Thu, 20 Jul 2017 06:00:26 GMT

Try to use: $(VST_ID) instead of VST_ID when referencing parameter in subroutine.

Tomasz

Re: Issue with the sub

fawazqutami — Thu, 20 Jul 2017 07:08:06 GMT

I used the qualified path but still the same error ... !

Re: Issue with the sub

fawazqutami — Thu, 20 Jul 2017 07:59:44 GMT

Still the same error "Error in expression: ')' expected:'"

Re: Issue with the sub

fawazqutami — Thu, 20 Jul 2017 11:24:47 GMT

Re: Issue with the sub

tomasz_tru — Thu, 20 Jul 2017 12:28:07 GMT

Can we see the whole script as it is now?

Re: Issue with the sub

fawazqutami — Fri, 21 Jul 2017 01:42:02 GMT

I believe that the issue is solved. but am not getting any records in TPP_SUM

Re: Issue with the sub

dwforest — Fri, 21 Jul 2017 15:20:07 GMT

You're not getting the ID in your loop.

Why not just join?

OPV: LOAD*FROM [lib://Stage2 (uranus_qlikadmin)/OPV_Table.qvd](qvd);

LEFT JOIN

VST_SUMM:

LOAD

IH_EMR_VST_ID as vstID,

Sum( SELF_PAYER ) as GUEST,

Sum( COMPANY_SHARE ) as PAYER

FROM [lib://Stage2 (uranus_qlikadmin)/C_REV.qvd](qvd)

;

Even if your loop did work, the resulting file would only contain the last ID as each would overwrite the previous.