Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview.
any help would b appreciated.
I am trying to do calculate Average with group by in Load Resident statement but it's not working.
I am getting invalid expression error.
Example :
TEST:
Load
OrderNumber,
AVG(Items)
Resident Test1
GROUP BY
OrderNumber;
can someone help me ?
Have you tried aliasing the field so:
Avg(Items) as AvgItems
Try different way see the load script
Eg:-
Test1:
Load * from Location;
Noconcatenate
TEST:
Load
OrderNumber,
AVG(Items) as Items //Give the name to this file is important
Resident Test1
GROUP BY
OrderNumber;
Drop Table Test1;
thanks for your reply.
I had tried and gave alias,
but, still, it's not working
do you have any other suggestions ?
TEST:
Load
OrderNumber,
AVG(Items) as [Item Avg]
Resident Test1
GROUP BY
OrderNumber;
Thanks for your reply.
still, it's not working.
do you have any other alaternatives ?
Do you have your qvw we can look at?
I think anand may be onto something, try putting the no concatenate before the load, so like:
TEST:
Noconcatenate Load
OrderNumber,
AVG(Items) as Items
Resident Test1
GROUP BY
OrderNumber;
Drop Table Test1;
Hi, Can you please share a sample of the Test1 Table with us? I would like to understand the meaning of the field items. Is it the number of items of an entire Order?
Eduardo
post the logfile of your reload
same name as your qlik doc, same folder,
enable it in menu --> settimgs --> document --> general --> generate logfile