Discussion Board for collaboration regarding Qlik DataMarket.
I have a requirement where i need to get the count of order lines for one order.
For this i have wrote a query like below, when i execute this i am getting the Invalid Expression general script error.
COUNT( DISTINCT OrderLineField) as Orders_Count
Group By Order_ID;
Can anyone of you please help me to resolve this:
Because you are using the wrong field in the group by statement
It should have been
LOAD * INLINE [
Count(DISTINCT OrderLine) as #Line
Group by OrderID
It is working thanks for correcting me