Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

Max record date

Hello All,

I have a table with multiple measures and column timestemp.

The data appear in intervals of 10 minutes.

I want to display only the values ​​listed in the table with the last interval.

I tried to build the table and chart style as well as table box and I could not do this with the command max (record_date (

Can anyone help me please?

Thanks in advance

Labels (1)
5 Replies
Anonymous
Not applicable

I'm not sure what you want - but try
max(total record_date)
or
max (all record_date)

MK_QSL
MVP
MVP

Aggr(Max(TOTAL Record_Date),YourFieldName)

amiroh81
Creator
Creator
Author

Hi,

max(total record_date) work!

can you Explain me what is the total command please ?

thank you very much

Anonymous
Not applicable

The "total" qualifier in this case tells to disregard chart dimensions.  If you use "all" - it disregards dimensions and selections.
(See "help")

amiroh81
Creator
Creator
Author

Thank you very much.