Max value Help

[h_prakash]

I have a Table in Fron End

Year  MonthNBR

2018  1

2018  2

2018  3

2019 4

2019  6

2020  3

2020 4

I want to create a table where I need to show Max monthnbr of each year. Result out put should look like

2018  1  3

2018  2  3

2018  3  3

2019 4   6

2019  6  6

2020  3   4

2020 4   4

This should be created in front end.  Please help in regards..

Thanks in Advance

Prakash

[pradosh_thakur]

Table1:

load * inline [
Year ,MonthNBR

2018 ,1

2018 ,2

2018, 3

2019, 4

2019 , 6

2020 ,3

2020 ,4
];
left join
load Year,max(MonthNBR) as Max_MonthNBR

Resident Table1
group by Year;

[h_prakash]

Thank you for the response. Actually I am looking for front end solution. The below table is a Table in Qlik Sense and the new column would be expression.

[tresesco · Accepted solution]

Dimension1: Year
Dimension2: MonthNBR

Exp:      Max( TOTAL <Year> MonthNBR)

[h_prakash]

Thank you for the solution. 

Hey if I want to create a Another field Where I need to Max Year across the out put. For Example my out put result should look like this.

2018 1 2020

2018 2 2020

2018 3 2020

2019 4 2020

2019 6 2020

2020 3 2020

2020 4 2020

[pradosh_thakur · Accepted solution]

You can try 

MAX({1} Year) or max(Total Year) whatever is suitable for you.

[h_prakash]

Thank You