Decode function

[Anonymous]

Decode(supply name, ' ',apname, supply name)-------how can I implement this in qliksense,can somebody please help.Thanks in advance.

[MarioCenteno]

May be try

Example

(case-sensitive)

=Pick(Match(Product, 'Y', 'N'), 'b', 'a')

(case-insensitive)

=Pick(WildMatch(Product, 'Y', 'N'), 'b', 'a')

[sunny_talwar]

May be this

If(Len(Trim([supply name])) = 0, 'apname', [supply name]) as [supply name]

[Anonymous]

I tried that ,but I didn't get the same result

[sunny_talwar]

Would you be able to share more details and may be a sample?

[Anonymous]

Ya sure,so if we talk about for 4 different I'd,all have the same supply Name,if we use that decode function,when I tried , by using if Len function and pick match function ,for one row out of 4 row,supply name is different .And if I add appname , what I found is that,that app name is similar to the odd supply name i.e my decode function didn't work properly.pls help

[sunny_talwar]

I am not sure I follow...and where is your sample?

[Anonymous]

I'd .   Supplyname

1.      Coat

2.       Coat

3 .      Coat

4.       Coat if we apply decode,we get that result

I'd.   Supplyname appname

1.    Coat.                 Coat

2.    Coat .                Coat

3.     North .            North

4 coat.                    Coat .  If I didn't apply decode