Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Nefertary
Contributor II
Contributor II

Average and gourp by with where clause in Load script

Hi Guru,

I Have created below script:

Capture.PNG

 

However It keeps giving me error:

Capture2.PNG

 

Can anyone help?

 

Labels (4)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

You missed Non aggregate fields in Group By statement

Test:
LOAD Year_CattleSL,
week_No_CattleSL,
Avg(USDA_meat_prod) as Avg
FROM
Help.xlsx
(ooxml, embedded labels, table is Sheet1) Where Year_CattleSL=2016 Group By Year_CattleSL, week_No_CattleSL;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Anil_Babu_Samineni

You missed Non aggregate fields in Group By statement

Test:
LOAD Year_CattleSL,
week_No_CattleSL,
Avg(USDA_meat_prod) as Avg
FROM
Help.xlsx
(ooxml, embedded labels, table is Sheet1) Where Year_CattleSL=2016 Group By Year_CattleSL, week_No_CattleSL;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Nefertary
Contributor II
Contributor II
Author

Thank you for the solution. It worked!!

Anil_Babu_Samineni

Great !! Please flag the correct answer If that resolved.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)