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: 
robinsond31
Contributor
Contributor

Pivot Chart with Balance for the last date in each period

I need to create a chart that will show the balance for the last date in each period. I have attached a file with the sample data and the results I am looking for. I was able to use the AGGR funtion to create a calculated dimension for the date, but I can't figure out how to get the value associated with that date.

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

you can use 

firstsortedvalue(Balance,-Date)

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

you can use 

firstsortedvalue(Balance,-Date)

robinsond31
Contributor
Contributor
Author

That worked. Thanks.
lironbaram
Partner - Master III
Partner - Master III

hi 

always happy to help 

please mark the answer as correct , so other user will now they can help someone else