Excel File with 2 Tables - Field to select in qvw-File

[#1]

Hi!

I have a small problem. In QlikView when Im importing an Excel File with two tables, how can I make an object (maybe a list box), where I can select which table should shown up? Maybe a field, where I can select "Spike 1 - Table" or "Spike 2 - Table" or booth - after that, the data of each table will shown up - and the data from the other table will be locked and I have to select the other "Spike - Table" first, to get into that data.

Is this achiveable?
Thanks for help!

[#2 · Accepted solution]

Hi,

Here you are a possible solution.

Best regards.

[#3]

Thanks for that quick help, I will look into this! But it seems clear now 🙂