Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF letter combo found then FALSE in new column

I am new to Qlik desktop and doing some testing. I have a number of items in a table. What I want to do is create a new (True/False) table. If the filed in a table has "V" at the end of a field I want the corresponding field to put in "FALSE"

Example

Table 1New Col (True/False)
12345VFALSE
abcdeVFALSE
1qaz2wsx
1234qwer
7652ygVFALSE

How does one do that in qlikview desktop?

TIA

3 Replies
sunny_talwar

May be this

If(Right([Table 1], 1) = 'V', 'False', 'True') as [New Col]

Not applicable
Author

I tried something like that then yours. I get back "unrecognized symbol: =" each time

sunny_talwar

Seems to work

Table:

LOAD *,

  If(Right([Table 1], 1) = 'V', 'False', 'True') as [New Col];

LOAD * INLINE [

    Table 1

    12345V

    abcdeV

    1qaz2wsx

    1234qwer

    7652ygV

];