This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have a XL sheet and columns name called id,month but month containing sales amount like 1000? but i want jan,feb...like under month? how?
pls tell me
Check this: Load Multiple excel sheets using For loop
View solution in original post
Can you share an example of your data, please? Because Im not sure understand and I don't want give you a wrong answer.
i have no sample app sorry for that and my questions is
in XL file i have 12 sheets and names like above i have mentioned and all 12 sheets fields are same only sheet names or different
my requirement is i want load all 12 sheets at a time in single load statement?
Ok you can try a "for each next" load, something like this:
FOR Each vMonth in 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'
(biff, embedded labels, table is $(vMonth)$);
pls share sample qvw or script in clear manner i am getting confusion over there
Here you are.