Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yanivvl0
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!

1 Solution

Accepted Solutions

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

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

Button->Action->Add->Select in field

Field -> field_1

Search string->

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

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), '|') & ')'

yanivvl0
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 !

yanivvl0
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 !

yanivvl0
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

Capture.PNG

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)
yanivvl0
Contributor III

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

THANKS!

yanivvl0
Contributor III

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

HI SUNNY  -   THANKS AGAIN  !