topic Re: problem with wildmatch or else save statement in QlikView

problem with wildmatch or else save statement

Anonymous — Tue, 28 Mar 2017 14:44:14 GMT

Hi all,

I am trying to take a resident load of the following statement from a Qlikview app and store it out to a new QVD that will be used in a Qliksense app, but it keeps failing at the save stage. Can anyone tell me where I'm going wrong please ?

T_Kick:
LOAD
kicktrn.int_code,
[Fat Class - Short],
[Grade code - Short],
kicktrn.cat_code,
kicktrn.Category_sorted,
killtrn.date_kick,
YearWeek,
kicktrn.eartag as [Kick Count]
resident kicktrn

where WildMatch(kicktrn.int_code,'TE*')
;

store T_Kick into \\idmgraqvshub12\Qlik_Sense_Data\T\T_Kick.qvd;

Thanks,

Kieron

Re: problem with wildmatch or else save statement

avinashelite — Tue, 28 Mar 2017 14:48:11 GMT

Whats the error your getting ?

I doubt on the \\idmgraqvshub12\Qlik_Sense_Data\T\T_Kick.qvd; access for this path ?

Re: problem with wildmatch or else save statement

sunny_talwar — Tue, 28 Mar 2017 14:56:29 GMT

May be you need to add (qvd) at the end

store T_Kick into \\idmgraqvshub12\Qlik_Sense_Data\T\T_Kick.qvd (qvd);

Re: problem with wildmatch or else save statement

shansundar — Tue, 28 Mar 2017 15:11:43 GMT

Check adding (qvd) before ; and if still its getting failed please check if you have write access to the path.

Thanks,

Shan S

Re: problem with wildmatch or else save statement

Anonymous — Tue, 28 Mar 2017 16:06:50 GMT

Thanks Sunny,

I added the (qvd) at the end but also need to specify the network drive letter also.

store T_Kick into S:\idmgraqvshub12\Qlik_Sense_Data\T\T_Kick.qvd(qvd);

Do you have any idea why that would be ?

Thanks,

Kieron

Re: problem with wildmatch or else save statement

avinashelite — Wed, 29 Mar 2017 05:12:26 GMT

if its a server path then \\idmgraqvshub12\Qlik_Sense_Data should work fine ...check the folder mount once and specifying the S:\idmgraqvshub12 means your target is local folder !

Re: problem with wildmatch or else save statement

Anonymous — Wed, 29 Mar 2017 09:14:01 GMT

Thanks Avinash,

I got it working. I needed to add c$ to my save statement and it works now.

\\idmgraqvshub12\c$\Qlik_Sense_Data

Thanks for all your help

Kieron