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: 
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.