Discussion Board for collaboration related to Creating Analytics for QlikView.
I Have created below script:
However It keeps giving me error:
Can anyone help?
You missed Non aggregate fields in Group By statement
Test:LOAD Year_CattleSL, week_No_CattleSL, Avg(USDA_meat_prod) as AvgFROMHelp.xlsx(ooxml, embedded labels, table is Sheet1) Where Year_CattleSL=2016 Group By Year_CattleSL, week_No_CattleSL;
View solution in original post
Thank you for the solution. It worked!!
Great !! Please flag the correct answer If that resolved.