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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pick cell data from Excel

I would like to pick data from a cell of Excel and which will use for calculation of straight table. Is it possible to pick cell data in "Text object or Input Box"?

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

I suggest you the following:

You can create a sheet in your excel document and in the cell A1 do a reference to the cell what you wanna get, then, you make a load for that new and only cell, getting the value.

I hope it helps you.

Regards.

View solution in original post

3 Replies
nathanfurby
Specialist
Specialist

I suggest you read up on QlikView basics again... or post an example of what you are trying to do.

Not applicable
Author

Hi,

I suggest you the following:

You can create a sheet in your excel document and in the cell A1 do a reference to the cell what you wanna get, then, you make a load for that new and only cell, getting the value.

I hope it helps you.

Regards.

Not applicable
Author

Yes, I got it, great! Thank you very much!!