Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

Lookup doesnt work???

Hi all

im trying to use a lookup for a reference line and the function isnt recognised by qlikview, any help?

thanks alot

1 Solution

Accepted Solutions
Not applicable

As Rob says, there is no Lookup() function in charts, but you can work around using only() and set analysis.

Say you are looking up customer and country. Put in the set analysis to ignore all selections, using the '1' just in case. Then set the field you are looking for to the lookup vaule.

eg

= only({1<Customer={"customer name"}>} Country)

The only() function will now return the country for that particular customer

Erica

View solution in original post

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Do you mean the lookup() function? That is only supported in script, not in charts.

-Rob

samuel_brierley
Creator
Creator
Author

ahh right that could be why then,

is there an equivelent that works in charts?

basically I have a 2 collumn table and i want to perform essentially a vlookup on it.

Not applicable

As Rob says, there is no Lookup() function in charts, but you can work around using only() and set analysis.

Say you are looking up customer and country. Put in the set analysis to ignore all selections, using the '1' just in case. Then set the field you are looking for to the lookup vaule.

eg

= only({1<Customer={"customer name"}>} Country)

The only() function will now return the country for that particular customer

Erica

Not applicable

BTW what are you trying to do? Becayse in the app, QlikView might just join the fields together for you anyway. Is this not working?

Erica

samuel_brierley
Creator
Creator
Author

Ahh thank you thats what im after

thank you!

Not applicable

No worries