This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have two reports of data but I want to generate a statement that will only show data from a field if it is populated, and if it isn't populated show the other field.
I know this is a generic IF statement but can't figure out how to word the IF statement for a populated field rather than a specific selection.
IF([Mike Risk Factor]=(no idea what to put here), [Mike Risk Factor], [Risk Factor])
IF(LEN(TRIM([Mike Risk Factor]))>0, [Mike Risk Factor], [Risk Factor])
View solution in original post
You may also want to cater for the case of the field being NULL by using
isnull([Mike Risk Factor])
IF([Mike Risk Factor]=' ', [Mike Risk Factor], [Risk Factor]) as Factor
Try this covering both an empty field and a null field
IF(TRIM([Mike Risk Factor])='' OR ISNULL([Mike Risk Factor]), [Risk Factor], [Mike Risk Factor])
My recommendation would already treat the field by removing the nulls with TRIM and it would check if the field size is greater than 0 with LEN thus perfectly servicing the request.