Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
PuriVelasco
Creator
Creator

Sum of data is under the limit and show in the same column

Hello,

I am working in the Load Script; I am working with data of stock for articles when they are under a limit.

But I have two articles which limit of stock is the sum of both.

I want to show this limit of two articles in the same column in a table, that the stock of single articles.

I have tried some posibilities but I always show the amount in a different column.

Thank you very much in advance!

1 Reply
PuriVelasco
Creator
Creator
Author

I need some similar to this:

if(EAN = 'xxxxxxx' or EAN = 'yyyyyy', sum(stockLineal), stockLineal) AS Control_stock_stockLineal,

 

But doesn't run the sum. I have already used the Group by but nothing.