Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhanu8804
New Contributor

Decode function

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

7 Replies
guitartrova
Contributor III

Re: Decode function

May be try

Example

(case-sensitive)

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


(case-insensitive)

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

Re: Decode function

May be this

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

bhanu8804
New Contributor

Re: Decode function

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

Re: Decode function

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

bhanu8804
New Contributor

Re: Decode function

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

Re: Decode function

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

bhanu8804
New Contributor

Re: Decode function

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

Community Browser