topic Script in QlikView

Script

rajni_batra — Mon, 16 Jan 2012 04:49:44 GMT

CustomerLedgerEntry:

LOAD

If(sum([Remaining Amount])>1000000 ,sum([Remaining Amount]),0) as Group1

Resident CustomerLederEntry;

DROP Table CustomerLederEntry;

during Reload it reflects invalid Expresion .. whats wrong????

Mon, 16 Jan 2012 04:52:10 GMT

Since you are using sum() function, you must have group by clause.

Regards,

Kiran Rokkam

rajni_batra — Mon, 16 Jan 2012 05:33:44 GMT

still giving the same error..

Mon, 16 Jan 2012 05:36:50 GMT

remove * after reload and substitute only those fields respect to which you want to take group by as:

load

[Remaining Amount],

If(sum([Remaining Amount])>1000000 ,sum([Remaining Amount]),0) as Group1

Resident CustomerLederEntry group by [Remaining Amount] ;

DROP Table CustomerLederEntry;

regards

vijit