Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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