Solved: replace inside Variable - Qlik Community

Anonymous · ‎2013-01-25

Hi,

I have variables

.

In Var 2 I need to replace A to '', if Var1=cc in script. Var 2 should be A and B

Anonymous · ‎2013-01-25

I get it.

In list box expression

IF(Var1<>'cc', Var2)

MayilVahanan · ‎2013-01-25

Hi

Load Var1,Var3

If(Var1 = 'cc','',Var2) as Var2

from tablename; //filename.xls

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Anonymous · ‎2013-01-25

Thank for reply.

I tried it.

In list box it shows A, B and ''.

How can I hide ''?

Regards,

Anonymous · ‎2013-01-25

I get it.

In list box expression

IF(Var1<>'cc', Var2)