Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can you help me get the right data.
So I want to calculate data and to use this two condition, because I have same name in some fields but with different brand name.
In excel I am using sumifs formula for maching the data with two condition and in qlik I can't use ti.
Sum(If(Something,Field))
You can nest as many if() statement as you want.
In most cases, it is better to use set analysis rather than if() statements in this context, but since you haven't specified what you're trying to do, I'm not sure if this is one of them.
So I want to calucate data and to use two condition, also I am using the data from 2 different tables.
SO:
to calculate all product with same code and within the same name.