Discussion Board for collaboration on QlikView Scripting.
I used this script to export straight table with each selection date_s(yyyy/mm)
Si have to store each file qvd with this ruls "straight"num_month .qvd
So i used this funtion NAMEFILE=Instr(String,6,2) to extract th month like MID() FUNTION
eg: 2017/10 title=10
but i have error Object required: '[string: "12/2015"]'
Go to Solution.
Yeah. Here is the correct code.
Why not you use right function?
we cAn use with macro RIGHT()?
You can use mid or right, but I'm guessing you will get an error with your filename. If val(item(i),Text contains "/". These are not valid symbols in file names. I usually use the replace function to replace "/" with "-".
Hi M W,
You are right. But Souad is taking only the month numbers (01, 02... 12) from the date field. So I am pretty sure, it won't throw any error.
thank you for your interactivity