Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am using 4 tabs from one spreadsheet as my source and loading it as a data table into my Qlikview dashboard, the problem I am having it..when I create graphs, they seem to not be pulling data from the other 2,3,& 4 tabs of the excel spreadsheet. Please advise.
Thanks !
Are the tables linked with a common field such as ID number?
All tables have common fields with the except of one new field being displayed in the additional table.. i.e. table 1 is showing SAP Paid employees per cycle, Table 2 WorkDay Paid employees per cycle, table 3 SAP Off cycle payments, table 4 Workday off cycle payments. table 1 and 2 have "system as SAP" and 3 and 4 have Category. all other fields are year, month, frequency.
Thanks !
Hi Iqra,
In script, you could load all the tabs in the same QlikView resident table using concatenate load. Then you would have 'Year', 'Month', 'Frequency', maybe 'Paid employees per cycle" filled only with information coming from tabs 1 and 2, and maybe 'Cycle Payments' filled only with information coming from tabs 3 and 4.
Regards,
H