Discussion board where members can get started with Qlik Sense.
im going to start using weather data, and it comes in this format per month in the same file. Lets call it weather.xls.
I've made named fields inside the excel file:
What i want to do:
1. Read only the tablenames in the list above.
2. Cross table the day of the month (1-30/31).
3. End result cross table: get a vertical list of normal TAM, TAM, RR with the corresponding day of the month. (1,2,3,4,5,6,7).
4. Add for each filelist [lib://desktop/weather*.xls] including the specific table names and cross table function.
I've only done cross table with two rows before and i don't know how to use import a named list of table names from excel file.
Hope you can help me out on this one.
hope this helps you The Generic Load