Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
im trying to use a lookup for a reference line and the function isnt recognised by qlikview, any help?
thanks alot
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
Do you mean the lookup() function? That is only supported in script, not in charts.
-Rob
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.
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
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
Ahh thank you thats what im after
thank you!
No worries