topic Re: Print only the value with min(date) in QlikView

Print only the value with min(date)

Thu, 09 Jul 2015 13:06:57 GMT

Hello Guys,

I'm having serious trouble to write this one.

I wan't to print only the value that has the min date. Like an initial value.

I've tried this: =Sum({$<Date={"=$(=min(Date))"}>} Value).

How can i do it? =(

alexandros17 — Thu, 09 Jul 2015 13:09:12 GMT

try

Sum( FirstSortedValue(Value, Date) )

Thu, 09 Jul 2015 13:12:00 GMT

Hi Alessandro,

This return: "Error: ERror in expression: Nested aggregation not allowed"

MK_QSL — Thu, 09 Jul 2015 13:12:41 GMT

SUM({<Date = {'$(=Min(Date))'}>}Value)

ger_alegria — Thu, 09 Jul 2015 13:13:21 GMT

Hello,

First, you can save in a variable the value of the min date:

vMinDate = min(Date) //Here you can choice if you want the min date of all data or the min date of the selection.

After that you can use the variable in expresion:

sum({<Date = {'$(=vMinDate)'}>}Value).

Let me Know if this help you.

alexandros17 — Thu, 09 Jul 2015 13:14:48 GMT

You're right, try with:

FirstSortedValue(Value, Date)

Thu, 09 Jul 2015 13:36:40 GMT

Thank's Guys!

Almost all of your answers has worked.