Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
AmCh
Creator
Creator

Field generation

Hi all,

starting from these Fields (to import):

cde
01,12,1
02,33,2
03,44,3
04,55,4
05,66,5
16,77,6
000

I want to generate the following fields, respecting these formula:

j=m*c (m: entered value from the user with an input box)

k=n*d (n: entered value from the user with an input box)

l=e

vMAX=MAX(j,k,l)

let's take as an example: m=0,5, n=2

jkl
02,22,1
04,63,2
06,84,3
095,4
011,26,5
0,513,47,6
000

 and then to pick the max value from the generated field (j,k,l)

vMAX
2,2
4,6
6,8
9
11,2
13,4
0

 

How can I write this in the script?

Thanks in advance.

Labels (4)
1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @AmCh !

    I think that attached app can help you.

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @AmCh !

    I think that attached app can help you.

Help users find answers! Don't forget to mark a solution that worked for you!
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hello @AmCh ! Can you mark the post as solved?

Help users find answers! Don't forget to mark a solution that worked for you!