topic Re: If condition select two values at a time in QlikView

If condition select two values at a time

anukrish — Sat, 16 Nov 2024 00:00:08 GMT

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

Re: If condition select two values at a time

Kushal_Chawda — Thu, 10 Sep 2020 11:04:29 GMT

@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

Re: If condition select two values at a time

anukrish — Thu, 10 Sep 2020 11:59:58 GMT

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

Re: If condition select two values at a time

Kushal_Chawda — Thu, 10 Sep 2020 13:05:53 GMT

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

Re: If condition select two values at a time

anukrish — Thu, 10 Sep 2020 13:12:59 GMT

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

Re: If condition select two values at a time

Brett_Bleess — Wed, 23 Sep 2020 11:32:59 GMT

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