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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

set analysis in calculated dimension

I wat to create calculated dimension  ,with set analysis expression

display the value of column x for the max date


Capture.PNG

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Well, if I go with sample screen shot, try like:

=Date(Max(total Date#(DATE,'YYYYMM')), 'YYYYMM')

View solution in original post

8 Replies
tresesco
MVP
MVP

May be like:

Only(Total {<Date={'$(=Date(max(Date)))'}>} Column)

tresesco
MVP
MVP

Well, if I go with sample screen shot, try like:

=Date(Max(total Date#(DATE,'YYYYMM')), 'YYYYMM')

sunny_talwar

C6 300 is on 201705, why would you be seeing that?

souadouert
Specialist
Specialist
Author

I want show always the lastest value

sunny_talwar

But C6's latest value is on 201705 and not 201706? how are you seeing this next to 201706?

souadouert
Specialist
Specialist
Author

y are raight sunny

sunny_talwar

So, is the issue resolved now? I am confused

souadouert
Specialist
Specialist
Author

Yes sunny thank youuuu