Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kokeeffe
New Contributor II

problem with wildmatch or else save statement

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

1 Solution

Accepted Solutions

Re: problem with wildmatch or else save statement

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 !

6 Replies

Re: problem with wildmatch or else save statement

Whats the error your getting ?

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

MVP
MVP

Re: problem with wildmatch or else save statement

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

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

shansundar
Contributor

Re: problem with wildmatch or else save statement

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

Thanks,

Shan S

kokeeffe
New Contributor II

Re: problem with wildmatch or else save statement

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

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 !

kokeeffe
New Contributor II

Re: problem with wildmatch or else save statement

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

Community Browser