Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Heya !!
New to this awesome BI Tool...
I hav a excel data base with 5 differents worksheets, and created a .qvw with 5 differents folders.
Each excel worksheet has the same columm names, but reffers to different category of data and i cant just gather all the data on only one woorksheet and place a columm with the names of the woorksheets as a category, i need the excel database to stay like it's now.
i need to load on my qvw all the 5 woorksheets that the excel has, but once i do that i use all the data on all qvw folders and, i need that to be restricted to load only the data inside the worksheet on the qvw folder with the same name.
I've placed a print with a drawning with what i need , hope you guys can help !!
Thx very much !!
The data which ae loaded into qlikview are in the background from a qlikview application and not on the surface like in excel. Therefore such a mandatory connection between (source)data and the various sheet-tabs didn't exists.
But this not really a problem because you could define on which sheet-tab which objects display which data - you will have have many (more) flexibility (then in excel).
- Marcus