Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarath123
Contributor III
Contributor III

how to write if condition on the script without loading the data using Inline fucntion

Hello,

I have the data as  attached below.
I need to calculate the total and company sales based on the code by writing on the script. I cannot use Inline function because I have huge data.
For code (1530) the sales should be sum of sales for code (1530)-code (1547)-code (15500140)-code (15500240)-code (15904001)-Code(15904002)-code (15904003)
Both Company and Total should be calculated like the above expression
Can someone help me to find a solution 

1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

try with the file attached

View solution in original post

4 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

try with the file attached

Sarath123
Contributor III
Contributor III
Author

Many Thanks 😊

Sarath123
Contributor III
Contributor III
Author

For the below data where both codes were mentioned

StarinieriG
Partner - Specialist
Partner - Specialist

Try to see the new file attached.

 

Now you have multiple fields for each code