topic Re: Look up using values from a multi sheet excel document in QlikView

Look up using values from a multi sheet excel document

martin_hamilton — Wed, 25 Nov 2020 16:16:04 GMT

I have an excel sheet with multiple tabs which have system values to descriptions tables within it.

I wish to use values from each tab in a look up against loaded tables.

When I load the data it places it all within 1 table in qlikview but I want to have it in multiple tables as values might be the same in each tab but mean differing things when looking it up as a reference.

So when I reference the Value in my look up it doesnt work. So the question is:

Is it possible to create differing tables from a single multi sheet excel document and if not how do I reference in the look up.

Attached is what I have set up currently.

Re: Look up using values from a multi sheet excel document

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:03:16 GMT

I've attached good example, Please have a look

Re: Look up using values from a multi sheet excel document

martin_hamilton — Mon, 26 Sep 2016 10:11:48 GMT

Hi Anil

Not exactly what I was looking for but inspired me to make a slight change and it worked perfectly.

Many Thanks

Martin

Re: Look up using values from a multi sheet excel document

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:14:14 GMT

Glad to help to resolve out