Using 2 columns of data to create another column depending on criteria

[beneldridge]

Hi all,

New to Qlik and stuck on some coding for something I would like to create:

I have 2 columns of numbers I would like to use for a new column depending on the status in another column:

Status	A	B	New Column
Delivered	10	20	20
Closed	10	20	20
In-Progress	20	0	20
Reserved	20	0	20

For example the top two rows I would like to take column B numbers into my new column and the bottom 2 rows from column A.

Can anyone help with this coding?

Thanks,

Ben

[vkish16161]

Ben,

Try this:

If (recno()<=2, B, A) as "New Column"

[MarcoWedel]

please don't create multiple threads for the same question:

Bringing 2 columns of numbers into a new column depending on criteria

thanks

regards

Marco