Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Tags (1)
3 Replies
sunny_talwar
Not applicable

Re: IF letter combo found then FALSE in new column

May be this

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

Not applicable

Re: IF letter combo found then FALSE in new column

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

sunny_talwar
Not applicable

Re: IF letter combo found then FALSE in new column

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

];