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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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!!