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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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.