topic If Statement in QlikView

If Statement

Fri, 27 Apr 2012 09:52:55 GMT

Can anyone help I'm very new to this and I want to create an expression for a column in a table that says gives me this field

Pipeline_bill_item.Bill_descript_item

but if there isn't a value for that field then give me this field

Pipeline_bill.Bill_descript

instead. So within the one column in the table if either field has a value it should be shown.

I think this is an IF statement.

Thanks

If Statement

jagannalla — Fri, 27 Apr 2012 10:13:40 GMT

If i understood the concept. You need to load the entire dataset first. After that you need to check the whether the field is null or not. If the field is null then drop that field otherwise drop another field.

For eg:

A,B,C are the fileds

If A is null drop the field A otherwise C.

- If you provide sample application we can work on it.

If Statement

Fri, 27 Apr 2012 10:40:16 GMT

Hi Jagan

I'm working on a designer license through my work with the script already set and data loaded I'm just adding in fields to tables and designing a webview for other users so I can't provide an application sample.

I can get the field names I mentioned in seperate columns but as the values only appear in one column or the other I wanted them combined into one column in the table using an expression. Is this possible?

Thanks

If Statement

m_woolf — Fri, 27 Apr 2012 10:59:03 GMT

=IF(isnull(Pipeline_bill_item.Bill_descript_item),Pipeline_bill.Bill_descript,Pipeline_bill_item.Bill_descript_item)

If Statement

Fri, 27 Apr 2012 11:39:14 GMT

Thanks spot on.