Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

hi 

you can use 

firstsortedvalue(Balance,-Date)

View solution in original post

3 Replies
Partner
Partner

hi 

you can use 

firstsortedvalue(Balance,-Date)

View solution in original post

Contributor
Contributor

That worked. Thanks.
Partner
Partner

hi 

always happy to help 

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