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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
miraculx
Contributor
Contributor
‎2022-08-05 04:31 AM

Lookup only work in Script - is there a runtime function ?

Lookup only works in the script - is there a similar function that I can use  after loading ? (specifically i will use in DECLARE FIELD DEFINITION Tagged).

 

 

Labels (1)
Labels
430 Views
0 Likes
2 Replies
JHuis
Creator III
Creator III
‎2022-08-05 04:38 AM

Hello,

 

maybe but in some sample data? Because if you have a good data model you dont have to use lookup. Qlik does it for you!

428 Views
0 Likes
miraculx
Contributor
Contributor
‎2022-08-05 05:31 AM
Author

Various organizational units participate in an analysis. Responsible for main and sub-processes as well as analysing.


Sample Data:

SAMPLE NO; LAB_A; LAB_B; LAB_C; LAB_D; result
samples 1; MR; PO; CA; HI; positive
samples 2; HR;UX;VL; negative

LAB, Group, Department, Country
MR; inst. X; veterinary; EN
PO; inst.y; human; FR
CA; Institute Z; medicine; HU
VL; Institute Q; human; IT

I want to use the 

DECLARE FIELD DEFINITION Tagged function analog autocalender to tag the LAB fields with Department, Country, State, .... 

This is an attempt to reduce the number of attributes through this feature

 

 

406 Views
0 Likes