Display the first value of the year

[pirotfab]

Hello, I look for the initial stock and final stock, over a year, for a customer

You know qlikview formulas for a table ?

Here is an example Excel

Thank you for your help

I am available for questions

[sunny_talwar]

You should be able to use

FirstSortedValue - chart function ‒ QlikView

But I am not fully sure if you have monthly data and you want to add initial and final or you just looking to have client as dimension and initial and final as expression?

[#3]

Hi,

As per your requirement. While loading data do crosstable and take Straight chart object.

Dimension: Client

Expression1: Min(transactions)

Expression2: Max(transactions).

Goto expression tab to remove grand total. Under expression tab, goto Total Mode and check no total.

I Hope this is you requirement.

Client	Initial	Final
client 1	1000	2100
client 2	1000	1800
client 3	1000	1600