ASK.. Loading problem, Need Help

[#1]

hello there need help plis,

really urgent, thank you before, wish you all have a good day.

why when i type min(date) in load script, it will error??

i need to get min(cicildate).

do i have to using group by syntax?? if so, what is the syntax??

plis see this discussion for more detail,

http://community.qlik.com/forums/t/32939.aspx

pliss really need your help..

many thank

regards!

[#2 · Accepted solution]

Hi

Please refer this script.

load

ID,

min(date)

resident table-name group by ID;

Regards

Ashish

[#3]

If you wanna execute same script as above use group by for all the fields in your script except those used under aggregation function.

[#4]

thank you,

i will try it later, and post the result here

thank you so much for your help

cheerss

[suniljain]

Pls Check This one.......

Min(Date(Cicildate)) as MinCicilDate

[#6]

ASK Again,

Hello All,

thank's to your help, now i can load min(cicildate) with this code,

load

NoRek as NoRek_CAD,

NoPin as NoPin_CAD,

min(date(CicilDate)) as MinCicilDate,

num(interval(today() - min(Date(CicilDate)))) as AgingDay,

from

(qvd) group by NoRek, NoPin;

but now i have another problem, which you may have already know,

the problem is how to select,

min(date(CicilDate)) where PaidSts = 0 As MinCicilDay,

because the real agingday is (today - MinCicilDay where PaidSts = 0)

What is the syntax of WHERE?

plis complete my syntax.

thank you for your help..

regards!!