Discussion board where members can get started with Qlik Sense.
I am new to qlik sense and need an expert help please.
I have a sample data as follows:
I want original balance for max " Ltrend Year" when particular "as of date" is selected.
Wanted to select max "LTrend Year" as my dimension for visualization. what is an expression for the same. Can someone please help with an expression.
What is the expected output from the sample data you have shared?
I'm assuming that you want your calculation to be made for each account, correct?
I'd try the following:
Dimension #1 = Account Number
Dimension #2 - max Year per account:
, [Account Number]
Measure: the balance that corresponds to the max year:
=FirstSortedValue([Original Balance], -Year)
I think this should give you the desired result. If it doesn't work as expected, please create a sample app and post it here, and I will take a look.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Boston, MA this October!
Is this what you expect?