Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Find Unique value

Hi All,

Is it possible below Output. Required output is Required logic need to Find Single value and Assign a flag 1 and 0.

 

DataA3&";"&B2Required Output
Apple  
AppleApple;1
OrangeOrange;Apple;1
Orange Orange ;Orange;Apple;0
OrangeOrange;Orange ;Orange;Apple;0
OrangeOrange;Orange;Orange ;Orange;Apple;0
BananaBanana;Orange;Orange;Orange ;Orange;Apple;1
BananaBanana;Banana;Orange;Orange;Orange ;Orange;Apple;0

 

In Above table Find Single value and assign 1 flag like 2nd row Apple. Thanks In Advance. 

Labels (2)
0 Replies