If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Decode(supply name, ' ',apname, supply name)-------how can I implement this in qliksense,can somebody please help.Thanks in advance.
May be try
=Pick(Match(Product, 'Y', 'N'), 'b', 'a')
=Pick(WildMatch(Product, 'Y', 'N'), 'b', 'a')
May be this
If(Len(Trim([supply name])) = 0, 'apname', [supply name]) as [supply name]
I tried that ,but I didn't get the same result
Would you be able to share more details and may be a sample?
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
I am not sure I follow...and where is your sample?
I'd . Supplyname
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