Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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