Date Period in X axis as date in different tab

[iliaisyah]

i have data as example excel.

i wish to have a flat table only in qlikview, to show monthly changes in each Block.

i wish to see the changes over the month but the date month seperated in each tab.

how i want to put it in qlikview

[agni_gold]

Below link will help you 

https://community.qlik.com/t5/QlikView-Scripting/need-to-load-all-the-sheets-in-excel-at-time/m-p/13...

[agni_gold · Accepted solution]

if you don't want to use macros , please use below code to load ,

ODBC CONNECT TO [Excel Files;DBQ=C:\Users\agnivesh_kumar\Downloads\DatabaseIDN qv dis.xlsx];
ExcelSheets: SQLTABLES; Sheets: Load Distinct TABLE_NAME Resident ExcelSheets where TABLE_TYPE='SYSTEM TABLE'; DROP Table ExcelSheets;

For i =1 to NoOfRows('Sheets')
Let vSheet = Replace(Peek('TABLE_NAME',$(i),'Sheets'),'$','');
Data:
LOAD * , '$(vSheet)' as Period
FROM
[C:\Users\agnivesh_kumar\Downloads\DatabaseIDN qv dis.xlsx]
(ooxml, embedded labels, table is $(vSheet));
Next;
Drop Field TABLE_NAME;