problem with wildmatch or else save statement

[Anonymous]

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

[avinashelite]

Whats the error your getting ?

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

[sunny_talwar]

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

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

[shansundar]

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

Thanks,

Shan S

[Anonymous]

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

[avinashelite · Accepted solution]

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 !

[Anonymous]

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