# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Contributor III

## How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

hi ,

i need to see population of field_1 where field_2 >= 20 or field_3>=30 ?

it dupose to be the population of all model ,

can anyone help me ?    by Button or any other way ..

thanks!

Tags (5)
1 Solution

Accepted Solutions
MVP

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

Also, you can use set analysis

='( '& Concat( DISTINCT {<field_2 = {'>= 20'}>+<{field_3 = {'>=30'}>} Chr(34) & field_1 & Chr(34), '|') & ')'

8 Replies
MVP

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

You can create one button on which you can set the action to select all the field_1 values

Field -> field_1

Search string->

='( '& Concat( distinct if(field_2 >= 20 or field_3>=30,chr(34) & field_1 & chr(34)),'|') & ')'

MVP

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

Also, you can use set analysis

='( '& Concat( DISTINCT {<field_2 = {'>= 20'}>+<{field_3 = {'>=30'}>} Chr(34) & field_1 & Chr(34), '|') & ')'

Contributor III

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

hi Kushal and Sunny , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

Contributor III

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

hi Kushal  , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

Contributor III

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

hi   Sunny , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

Seems, You made mistake over here. Remove = and then try

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III

THANKS!

Contributor III

## Re: How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

HI SUNNY  -   THANKS AGAIN  !