Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
avinashelite

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 !

View solution in original post

6 Replies
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
Partner - Creator
Partner - Creator

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

Thanks,

Shan S

Anonymous
Not applicable
Author

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

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
Not applicable
Author

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