Discussion board where members can get started with Qlik Sense.
I need your help with this. I have a table below as an example.
I need to create a new column with Apple cells only. Maybe like this. Please help me.
Go to Solution.
if(Wildmatch(Brand,'apple'),Brand) as NewCol
Try using applymap and mapping load:
LOAD * INLINE [
ApplyMap('Newcolumn',Brand,Null()) as New
(ooxml, embedded labels, table is Sheet2);
if (brand='apple',brand,'-') as newapple