Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use an especific excel worksheet as database for an especific qlikview folder?

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 !!qlikviewconections.png

1 Reply
marcus_sommer

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