Qlik Community

New to Qlik Sense

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
PrashantRupani
Creator
Creator

Max of year in Qlik Sense table

YearSales:
LOAD * INLINE [
Year, Sales
2014, 300
2014, 400
2015, 200
2015, 600
];

I used the above inline code to load the data. 

 

Then I used a table object on a sheet.  I need to have a column Max of Year. It should display the max year in the data set in every individual row of the table. How should I accomplish that?

 

PrashantRupani_0-1599660735173.png

 

Labels (1)
2 Solutions

Accepted Solutions
Taoufiq_Zarra

you mean Max(total Year) ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Taoufiq_Zarra

in expression modified Max(year) by Max(total Year)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

4 Replies
Taoufiq_Zarra

you mean Max(total Year) ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
PrashantRupani
Creator
Creator
Author

Yes. I am looking for max of total year

How do I accomplish that? I am new to QS

Taoufiq_Zarra

in expression modified Max(year) by Max(total Year)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
PrashantRupani
Creator
Creator
Author

Thanks. This helps. I learned today something new. Happy.