Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

robinsond31
New 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

Re: Pivot Chart with Balance for the last date in each period

hi 

you can use 

firstsortedvalue(Balance,-Date)

3 Replies
Partner
Partner

Re: Pivot Chart with Balance for the last date in each period

hi 

you can use 

firstsortedvalue(Balance,-Date)

robinsond31
New Contributor

Re: Pivot Chart with Balance for the last date in each period

That worked. Thanks.
Partner
Partner

Re: Pivot Chart with Balance for the last date in each period

hi 

always happy to help 

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