Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Max

I have 2 Different Tables which does not have any matching Columns

Table A

SalesID

Location 

Sales amount

Retro amount

Written amount

 

Table B

Account ID

Gross Amount

signed amount

I would like to take Max(Min(Max(Min(Max of Sales Amount and Gross Amount...,0),Signed Amount),Retro Amount),0)

and would like to do only on script

Labels (2)
3 Replies
Highlighted
MVP
MVP

@raadwiptec  can you please elaborate

Highlighted
Creator II
Creator II

I have 2 files which i have loaded as Table A and Table B in the Load script ... Loaded as below 

Table A

SalesID

Location 

Sales amount

Retro amount

Written amount

 

Table B

Account ID

Gross Amount

signed amount

 

I would like to make a new field  Called 'Range' -- > Max(Min(Max(Min(Max of Sales Amount and Gross Amount...,0),Signed Amount),Retro Amount),0) . But i would like to put this the new field using script;

 

Is this possible to link  these tables somehow and then create this new field .?

Highlighted
MVP
MVP

@raadwiptec  Can you share sample example with expected output?