topic Please help in QlikView

Please help

Wed, 11 Apr 2012 13:29:24 GMT

I am trying out this expression in my script ,but it is not working...

Calculation:

Load

if(bilunit=2, sum(losalrate*loaactwt*1000)) as A,

itemproduct

Resident loadingchallan

Group by itemproduct;

But while reloading it show this error

Field not found - <losalrate>

Calculation:

Load

if(bilunit=2, sum(losalrate*loaactwt*1000)) as A,

itemproduct

Resident loadingchallan

Group by itemproduct

I have also try the another expression

Calculation:

Load

if(bilunit=2, losalrate*loaactwt*1000) as A,

itemproduct

Resident loadingchallan

Group by itemproduct;

the error mess occur as

Aggregation expressions required by GROUP BY clause

Calculation:

Load

if(bilunit=2, losalrate*loaactwt*1000) as A,

itemproduct

Resident loadingchallan

Group by itemproduct

so please help me out

Re: Please help

CELAMBARASAN — Wed, 11 Apr 2012 13:35:41 GMT

Hi,

Check with this

Calculation:

Load

sum(losalrate*loaactwt*1000) as A,

itemproduct

Resident loadingchallan where bilunit=2

Group by itemproduct;

Re: Please help

Wed, 11 Apr 2012 13:50:52 GMT

it is showing the error

Field not found - <losalrate>

Calculation:

Load

sum(losalrate*loaactwt*1000) as A,

itemproduct

Resident loadingchallan where bilunit=2

Group by itemproduct

Re: Please help

CELAMBARASAN — Wed, 11 Apr 2012 13:53:38 GMT

Hi,

Then check you have field losalrate in the table loadingchallan.

Also check whether it is in same case.

Celambarasan

Please help

Anonymous — Wed, 11 Apr 2012 13:55:51 GMT

Is there a field "losalrate" in the table "loadingchallan"?

Re: Please help

Thu, 12 Apr 2012 04:44:13 GMT

sorry there was spelling mistake...

Thank u for ur help