Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ben,
Try this:
If (recno()<=2, B, A) as "New Column"
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