Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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