Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hard Cross table to load

Hi Community,

I have some problems in loading a Excel file that holds a complicate crosstable.. In fact, I have in the first column nouns of OPCVMs, whitch devided by category (OPCVM Monétaire, OPCVM OCT,...). Plus, each other field is a Date that Qlikview note recognize as date

I try with macros to change my excel file, but no way

many thanks in advance!

Regards,

Mohamed Ali

2 Replies
evan_kurowski
Specialist
Specialist

Hello Mohamed Ali,

It is easy to see why that spreadsheet presented some challenges but I think I have something for you.  There were 4 tabs in the spreadsheet, but only tabs [Lib] and [Pf] seemed to relate to the cross tables.  I imported the first tab [Lib] for you into a sample application.  You can follow these techniques to get the second tab [Pf] sorted out.  (Also, I noticed that there were cells of data way off to the right sometimes, if possible you may want to clear out all cells outside of the data area you want to render)

It looked like your dates were coming in as a numeric values stored as a text() data type.  To convert to the proper format they had to go from Text to Number using Num#() and then wrapped in Date() - i.e.   Date(Num#(Date),'MM/DD/YYYY')
20140811_Crosstable_transform.png

Not applicable
Author

Hello Evan !
This is a great job i found, i succed to load the "Pf" file following the script you wrote, and its works ... Thanks a lot for your disponibility and your generosity

Best Regards

Mohamed Ali