uploading

[raadwiptec]

hi all,

I have attached an excel data ..could you let me know how can i upload this document in qlikview so data is represented correctly . i tried using cross tab option but not giving me correct out put..

kindly suggest

[raadwiptec]

hi remi,

I have attached the file. can you please check and let me know .. i tried changing the header lines in the script to 4..but it gives me strange results

[raadwiptec]

hi remi,

if you provide me your email id it would be great.. i can send you the non edited file.. as due to data privacy i do not prefer to share the file in forum..

let me know thanks

[effinty2112]

Hello,

          Try this

CrossData:

LOAD *

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null)),

Replace(3, top, StrCnd(null))

));

RENAME Field Month to Qtr;

RENAME Field May to Month;

RENAME Field F3 to ValueField;

Data:

CrossTable (Printer,Value,4) LOAD * Resident CrossData;

Drop Table CrossData;

Cheers

Andrew

[raadwiptec]

hi andrew

can i send the actual file to ur email..again i have some header issues similiar to remi...?But even your code is giving good results...

[remi_roland]

Hi,

I updated the code to adapt it to your new xlsm file.

The main difference beetween the first and the second one were the extra-header line and extra hidden column before and above the table.

Hope it willl be good for you now.

P.S: I also added the year in filter.

Regards.

Remi.

[effinty2112]

Hello,

          Yes send me the file, you'll get my e-mail address from my profile.

cheers

Andrew

[raadwiptec]

hi andrew.. i dont find ur mail address over here?

[raadwiptec]

hi remi,

Thanks.. but sorry when i link to the my actual file... all data gets criss crossed. and data goes to type.. etc like that.....and does not come to as expected...

Probably i need to provide you the orginal file....but as mentioned in the forum it is difficult as due to the data privacy...

[raadwiptec]

Hi Remi

Can I send you the orginal file to your mail id? Please confirm

[remi_roland]

Hi Raadwiptec,

It's still not good for your excel sheet?

Sure you can send it to me,I will have a look at it to adapt that script to your data format.

Please send me also an exemple of the output format you want if what I did in qvw does't suit.

Regards.

Remi.