Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fipsarqlik
Contributor II
Contributor II
‎2022-04-22 03:40 AM

is sum() supported in where of Load script

Is the sum function supported in where condition of Load script

If it is supported can we use 

Load id from salary where sum(gross) > 100000 Group By id 

If not what is the alternative for this requirement

 

Labels (4)
Labels
293 Views
0 Likes
1 Solution

Accepted Solutions
vchuprina
Specialist
Specialist
‎2022-04-22 04:05 AM

Hi,

You can use Preceding load to filter data after aggregation:

Data:
LOAD
     ID
Where gross>10000;
LOAD
     ID,
     SUM(gross) AS gross
Resident Data_TMP
Group By ID; 

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

View solution in original post

286 Views
1 Reply
vchuprina
Specialist
Specialist
‎2022-04-22 04:05 AM

Hi,

You can use Preceding load to filter data after aggregation:

Data:
LOAD
     ID
Where gross>10000;
LOAD
     ID,
     SUM(gross) AS gross
Resident Data_TMP
Group By ID; 

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
287 Views