Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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

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