Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anukrish
Contributor
Contributor

If condition select two values at a time

Hi I am new to qlik 

I have a table with two values Y and N

I have to select two values at a time 

Frist select n values and other one select both y,n values

I use

if(field name=n,0,1) as field name

it select n value but other side I need y,n values into other selection

It only select one value but I need to select both Y and N values at a time

Labels (2)
5 Replies
Kushal_Chawda

@anukrish  Is there specific reason you want to select two values. Because if do not select anything means  both value is by default like selected

anukrish
Contributor
Contributor
Author

Yes 

If(field=N,0,1)

N=0 it select N values other wise it select Y value but

I need both Y,N values select in 1 place 

 if(field=N, 'N',  'both Y,N values'). 

like this is it possible or not I want to know

Kushal_Chawda

Well it is possible but need to understand the use case of doing it.

anukrish
Contributor
Contributor
Author

I am new to qlik so I am learning that's why I have this problem so I am looking for solution

Brett_Bleess
Former Employee
Former Employee

I would recommend looking over in the Design Blog area of Community, lots of how-to related posts there, believe you will likely find some things that may give you some further ideas on things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

The only other thing would be providing QVW file, so folks can see in a bit more detail what things look like in the data model etc. too.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.