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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Dimension

Hi ALl,

In Dimension i have a field called " Depaertment "

now i wat to display the Departments for the Max date of "Date" field ..

How to wright this in Calculated Dimesion ..

Will it be like this ?

max(Date),Department

Please provide siggestions ..


Thanks in Advance

23 Replies
Anil_Babu_Samineni

I have seen many thread which you created, And every time you are asking without data only. Make sure, As always you need to prepare one document related the issue. Because we are not of your project..

I am getting, There is no expression in my report? You are not looking this?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
smilingjohn
Specialist
Specialist
Author

Ok sir,

i will follow that from now

imrasyed
Partner - Creator II
Partner - Creator II

Did you try this    =Only({$<date={"=max(Date)"}>}Department).


For chart add AGGR func

Anil_Babu_Samineni

Great, You can Mark helpful for others as well which is proposed in suite of this requirement..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful