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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create one new filed from three filed on table

Hi all

I have table as following:

load * inline [

Checker,Picker,Driver

1,4,2

1,1,4

2,6,5

];

now i need to create on filed called (Role) contain ( Checker | Picker | Driver ) as text, to use on front as list box,

when user click on checker he will get only the checker in related information,

is there any suggestion to do it?

Thanks on advance

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

If I understand what you are trying to accomplish:


load
'Checker' as Role,
Checker as ID
resident Data;

load
'Picker' as Role,
Picker as ID
resident Data
load
'Driver' as Role,
Driver as ID
resident Data;
[\code]


<div></div></body>
Ask me about Qlik Sense Expert Class!