Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Re: to create a new field in depence on another fieldname

Thanks a lot Stefan,

the table does look great, i have a question, how can add the field: Ansatz in this procedure?

MVP
MVP

Re: to create a new field in depence on another fieldname

Shouldn't Ansatz equal USERFIELD1 resp. USERFIELD2?

beck110979
Valued Contributor III

Re: to create a new field in depence on another fieldname

Hi Stefan, sorry for bother

i want to achieve this output

ID, USERFIELD1, USERFIELD2, Ansatz

1,  70,  30, 100

2,  80, 20, 80

MVP
MVP

Re: to create a new field in depence on another fieldname

Sorry, I think it's too late for me to understand what determines the single Ansatz value you want to show in each line.

Try to describe the keys that link your two tables or the algorithm how you get the Ansatz in each line in more detail, then you should find someone here in the forum who might help you with the script syntax.

beck110979
Valued Contributor III

Re: to create a new field in depence on another fieldname

Nonetheless, Thanks a lot Stefan for your help and response

Re: to create a new field in depence on another fieldname

Overall it seems you need one master table for this may be helpful for you and do the mapping or the left join on the table.

Highlighted
beck110979
Valued Contributor III

Re: to create a new field in depence on another fieldname

Hi Anand, thanks a lot for your responce and feedback, i try to implement it

Community Browser