Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

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

1 Solution

Accepted Solutions
6 Replies
Not applicable
Author

Hi,

Can you share an example of your data, please? Because Im not sure understand and I don't want give you a wrong answer.

Regards.

Not applicable
Author

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?

Not applicable
Author

Hi,

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'

     LOAD

          Field1,

          Field2,

          FieldN

     From [..\source\XLFile.xlsx]

     (biff, embedded labels, table is $(vMonth)$);

NEXT vMonth

Regards.

Not applicable
Author

pls  share sample qvw  or  script in clear manner i am getting confusion over there

Not applicable
Author

Sure,

Here you are.

Regards.