Get a specific value of an IF clause

[Mazilinho]

Hello!

I have a column in a table calculated with an IF clause (IF Field1=1 and Field2=2 and Field 3=3, 'Yes','No').  

I want to display the results based on a variable selection. When one variable is selected, display only the results that have Yes, when another, display the No results. 

Can someone please advise me how to achieve this? Thanks!

[deepanshuSh]

Hi, The topic seems incomplete, what are you trying to call in a variable? what are you trying to select?

[Mazilinho]

Basically i want to filter the values. When one button (a variable) is selected, display only Yes values, when another button is selected, display only No values.

[deepanshuSh]

Based on the information provided, it can work like this. 

Do this field creation on the backend and create a separate if and els condition on the front end.

IF (Field1=1 and Field2=2 and Field 3=3, 'Yes','No') as new_field

if(getselectedcount(fieldName)>0, Count({new_field={'Yes'}}new_field), 

if(getselectedcount(fieldname)>0, Count({new_field={'No'}}new_field)))

If want to do it only on front end use master dimension for ease of usage. 

[Mazilinho]

I don't need to calculate the count.