topic Re: group by error in QlikView

group by error

farolito20 — Mon, 31 Dec 2012 17:08:27 GMT

LOAD

t_bpid,

t_nama,

t_ccur,

date(now()) as ValidFrom,

Timestamp#('31-12-2099 08:00:00','DD-MM-YYYY hh:mm:ss') as ValidTill,

//date(now()) as ValidTill,

Checksum,

1 as MostRecent

Resident DimOld

Where exists (Checksum2, Checksum) and t_bpid = $(vCustomerNumber) and MostRecent=0

Group By MostRecent

The error: aggregation expressions required by group by clause

shree909 — Mon, 31 Dec 2012 17:15:53 GMT

Hi,

i am not sure but if u are uisng group by clause u need to have aggregations .

but in ur case i dont find any aggregations (like , sum , count,max.....)so group by doesnt work

if i am wrong can u post a sample file

thanks

farolito20 — Mon, 31 Dec 2012 17:18:51 GMT

Ok, Thanks

I need to load just one row of this load, do you know how?

And another question, Do you know how to know if a table is empty?

farolito20 — Mon, 31 Dec 2012 17:20:45 GMT

My table is resident :s

shree909 — Mon, 31 Dec 2012 17:22:54 GMT

if u want to load one row take the unique id of the field use match function..

where match( fieldname, value)

farolito20 — Mon, 31 Dec 2012 17:28:54 GMT

what is match and how to use it?

MayilVahanan — Mon, 31 Dec 2012 23:59:48 GMT

have a doubt? can u able to clarify? which row u want? only one row or value?

first can use in this case , if u want to load first row only in a table.

if u want to load a rows based on a value,

load a,b,c resident tablename where b = '12';

in the above case , it load oly row which contain b has 12

in ur example, u assigning 1 as mostrecent? but in where condition usong mostrecent = 0?

i think due to this oly u can't able to get values.