Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

change expressions to yes/no

Dear,

From my qvd I load many customers. Some of the customers have a number, others not. I want to show in my chart if a customer has this number, with a "Yes".

Load from QVD:

Customer       Number   

A                    9876543213

B                    2135743518

C

D              

E                    3486135464

I want to show:

Customer     Number

A                  Yes

B                  Yes

C                  No

D                  No

E                  Yes

I hope this is possible.

thanks a lot!

Best Regards,

Sander

Tags (1)
1 Solution

Accepted Solutions

Re: change expressions to yes/no

Load

customer,

if(Len(NUmber)>0,'Yes','No') as Number

from

....

let me know

3 Replies

Re: change expressions to yes/no

Load

customer,

if(Len(NUmber)>0,'Yes','No') as Number

from

....

let me know

Highlighted
Not applicable

Re: change expressions to yes/no

It can also be done using

if(isnull(Number),'No','Yes') as Number

Not applicable

Re: change expressions to yes/no

Perfect!

thanks a lot!