Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhijith28
Creator II
Creator II

value of the field which has only particular flag

Hi All,

Consider i have more than 10 fields in my Qliksense app

i have two fields, each "Name" can have multiple Y and N 

Name,Flag

A,Y

A,N

A,Y

A,Y

B,N

B,N

B,Y

B,Y

C,N

C,Y

C,Y

I need to return the  value of "Name" separated by a comma (,) in the text box    ex: A,B

Condition: User might select any 10 fields throughout the app but it should return only those Names which has only count(Flag=Y)>1 and count(Flag=N)=0. else "0"

 

Thanks,

Labels (1)
0 Replies