Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

h_prakash
Contributor

Max value Help

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

 

 

 

Labels (1)
2 Solutions

Accepted Solutions
MVP
MVP

Re: Max value Help

Dimension1: Year
Dimension2: MonthNBR


Exp:      Max( TOTAL <Year> MonthNBR)

pradosh_thakur
Honored Contributor II

Re: Max value Help

You can try 

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

Learning never stops.
6 Replies
pradosh_thakur
Honored Contributor II

Re: Max value Help

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;
Learning never stops.
h_prakash
Contributor

Re: Max value Help

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.

MVP
MVP

Re: Max value Help

Dimension1: Year
Dimension2: MonthNBR


Exp:      Max( TOTAL <Year> MonthNBR)

h_prakash
Contributor

Re: Max value Help

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
Honored Contributor II

Re: Max value Help

You can try 

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

Learning never stops.
Highlighted
h_prakash
Contributor

Re: Max value Help

Thank You