topic Re: Using 2 columns of data to create another column depending on criteria in QlikView

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

beneldridge — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 18 Oct 2018 17:38:31 GMT

Ben,

Try this:

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

MarcoWedel — Thu, 18 Oct 2018 19:37:01 GMT

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

thanks

regards

Marco