topic ASK.. Loading problem, Need Help in QlikView

ASK.. Loading problem, Need Help

Wed, 18 Aug 2010 10:00:16 GMT

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!

ASK.. Loading problem, Need Help

Wed, 18 Aug 2010 10:04:28 GMT

Please refer this script.

load

ID,

min(date)

resident table-name group by ID;

Regards

Ashish

ASK.. Loading problem, Need Help

Wed, 18 Aug 2010 10:07:34 GMT

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

ASK.. Loading problem, Need Help

Wed, 18 Aug 2010 10:47:46 GMT

thank you,

i will try it later, and post the result here

thank you so much for your help

cheerss

ASK.. Loading problem, Need Help

suniljain — Wed, 18 Aug 2010 11:03:20 GMT

Pls Check This one.......

Min(Date(Cicildate)) as MinCicilDate

ASK.. Loading problem, Need Help

Wed, 18 Aug 2010 13:25:41 GMT

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!!