topic Re: First numeric value in table in QlikView

First numeric value in table

Michiel_QV_Fan — Thu, 20 Apr 2017 06:03:54 GMT

Hi, I need to find the first value in a table:

The table consists of these dimensions:

ProductID
reporting month
country

Fact:

Amount

And the values are a running sum where the first value is the start value.

I want to calculate the monthly difference which is easy but I do not get the starting value for each ProductID, reporting month etc. right. I keep on finding the first value of the total table or the last value of the previous product etc.

I tried previous functions, min(reporting month) in group by, peek etc but no luck so far.

Re: First numeric value in table

Anil_Babu_Samineni — Thu, 20 Apr 2017 06:13:23 GMT

Better to provide Sample data

Use something like below

=FirstSortedValue(Amount, -Aggr(Sum(Amount),ProductID))

Re: First numeric value in table

gardenierbi — Thu, 20 Apr 2017 06:14:12 GMT

Did you try with FIRSTSORTEDVALUE ?