topic Re: get a value from the list by date in QlikView

get a value from the list by date

Tue, 09 Oct 2012 21:10:15 GMT

I have two fields:
Date - Dias_Plazo
02/07/12 - 20
02/07/12 - 40
02/08/12 - 30

The grouping by date dias_plazo to take either higher or lower in the list.

I used:

=aggr(max(Dias_Plazo),MakeDate(var_ano_1,var_mes_1,var_dia_1)))

Not function el makedate.

Help me please,

Re: get a value from the list by date

swuehl — Tue, 09 Oct 2012 22:24:12 GMT

The aggr() function does not take calculated dimensions, only fields, and all arguments after the very first are dimensions to the aggr() function. So MakeDate() is not allowed as second argument / aggr() dimension.

I am not quite sure what you want to achieve with your expression, are you maybe looking for something like the FirstSortedValue() function?

Re: get a value from the list by date

Tue, 09 Oct 2012 22:36:19 GMT

FirstSortedValue () function does not accept duplicate values in the sort field,
= Firstsortedvalue (Dias_Plazo, MAKEDATE (var_ano_1, var_mes_1, var_dia_1)).
in case of a repeat date me sent null

help me please

Re: get a value from the list by date

swuehl — Tue, 09 Oct 2012 22:42:49 GMT

You can use DISTINCT qualifier to get an answer:

=FirstSortedValue(DISTINCT Dias_Plazo, .....)

I still don't get what you are trying to achieve with the makedate() function. I assume var_ano_1 etc are variables, right?

Can you give us an example input and desired output?

Re: get a value from the list by date

Tue, 09 Oct 2012 23:05:29 GMT

variables are var_ano_1 etc.
I have a

Dos Campos:

Dias_Plazo and Date (var_ano_1, var_dia_1, var_mes_1)
20   -                02.01.2012
30 -                 02.01.2012
40,                    03.01.2012
I need to get for example the value 30 of field Dias_plazo, and he has the same date as the value 20.

How do I get the value if both have the same date

Re: get a value from the list by date

swuehl — Tue, 09 Oct 2012 23:16:08 GMT

So you have two fields, Dias_Plazo and Date, and three variables. The user sets the variables and you want to look up the max Dias_Plazo for the Date field value that equals the created date using the variables?

Maybe like

=max( if(Date=makedate(var_ano_1,var_mes_1,var_dia_1),Dias_Plazo))

=max({<Date= {$(=makedate(var_ano_1,var_mes_1,var_dia_1))}>} Dias_Plazo)

Re: get a value from the list by date

Tue, 09 Oct 2012 23:30:16 GMT

Thank you,

I worked the first option

thank you very much