Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Find max value and place it at the end of the table

i have this kind of data 

 

Untitled.png

now i want max  value at the end like .. i am trying which is max in all month  by naming category for example

in  "a_Col" code_name in a name and in all month max value is 3141 and

for  b_col max value is 2139 in all months in b name 

 

so trying to get this type of result

name monthjan  feb  march  max value for a_colmax value for b_col
 code_namea_colb_colc_cola_colb_Colc_cola_colb_colc_col  
a 31412139       31412139
b     10458 7173388389717310458
c 559554454953405 5755   5595544

    



 

If any question let me know            

3 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

As you have added month dimension horizontally all the expressions you add will be split by month.
capriconuser
Creator
Creator
Author

yes i know .. but i want max amount at the end from all this .. this is what i want
capriconuser
Creator
Creator
Author

?????????????