Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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...
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.
Hello,
Yes send me the file, you'll get my e-mail address from my profile.
cheers
Andrew
hi andrew.. i dont find ur mail address over here?
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...
Hi Remi
Can I send you the orginal file to your mail id? Please confirm
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.