Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

@raadwiptec  can you please elaborate

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 .?

MVP
MVP

@raadwiptec  Can you share sample example with expected output?