Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator 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
sunny_talwar

Also, you can use set analysis

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

View solution in original post

8 Replies
Kushal_Chawda

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

sunny_talwar

Also, you can use set analysis

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

View solution in original post

yanivvl0
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

am i missing something ?

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

yanivvl0
Creator III
Creator III
Author

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

am i missing something ?

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

Anil_Babu_Samineni

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
Creator III
Creator III
Author

THANKS!

yanivvl0
Creator III
Creator III
Author

HI SUNNY  -   THANKS AGAIN  !