Using an If statement to show different data

analystdude96 — Tue, 07 Apr 2020 14:31:37 GMT

I have a dataset that looks like this

Name Status Result

Jeff Yes 1

Mark No 0

Tim Yes 1

Sarah No 0

In the field expression editor of both the Result and Status columns, I have used the following to only display those rows with both a 'Yes' in the Status column and a 1 in the 'Result' column, using these lines of code:

=if(Result =1, Result )

=if(Status ='Yes', Status)

So my app now displays :

Name Status Result

Jeff Yes 1

Tim Yes 1

My problem is that I now want the Result column to show 'Accepted' instead of the number 1, as that doesn't make much sense as just an integer so I need text here instead.

Any help would be appreciated greatly.

Thank you

Re: Using an If statement to show different data

m_woolf — Tue, 07 Apr 2020 16:49:54 GMT

=if(Result =1, 'Accepted')

topic Using an If statement to show different data in QlikView

Using an If statement to show different data

Re: Using an If statement to show different data