Create an IF statement that allows for multiple result outputs

Question

I am trying to filter out data based on a value in a column either a 1 or a 0. I can get it to filter out the 1 or the 0, but I would also like to be able to show all columns both 1 and 0. I have tried varying things and they either come out with a range issue or an issue with it not being completely specified. The user has the ability to input in a radio box if they want 1, 0 or both, but I cannot get both to show up without an error.

(Current Data Table() << Data Filter(
Mode( Show( 1 ), Include( 1 ) ),
Inverse( 0 ),
invisible,
Add Filter(
    columns(:Fine),
     Where(IF(V=="Coarse", :Fine==0, V=="Fines",:Fine==1,V=="Both",:Fine >=0 ))))), //Coarse, Fines or Both are selected in a previous code that works well.

GregRupp · Answer

My column (:Fine) is continous. If I understand correctly :height in this example is continous and you are setting a range. However, I am trying to set-up an "IF" statement in a "Where" statement. Current Data Table() << Data Filter( Location( {314, 74} ), Add Filter( columns( :age, :height ), Where( :age == {12, 14} ), Where( If( x=="tall",:height >=72, x=="average", :height >= 58 & :height <= 66, x=="Short", :height <= "58" ), // x is selected previously in a radio box. Display( :age, Size( 160, 90 ), List Display ) ) ); If I do something like this. It comes up with an error that says the "Where" clause has not been correctly specified 2 times.

txnelson · Answer

Is your column named :Fine defined as a continuous column?  If it is Ordinal or Nominal your syntax is correct, however, if it is Continuous, the syntax is as listed below

Current Data Table() << Data Filter(
	Location( {314, 74} ),
	Add Filter(
		columns( :age, :height ),
		Where( :age == {12, 14} ),
		Where( :height >= 58 & :height <= 66 ),
		Display( :age, Size( 160, 90 ), List Display )
	)
);

GregRupp · Answer

Thank you for sharing this code with me. I tried the code in a separate script and see that it works the way I would like my code to. However it is not working for me, does this only work for nominal sets? I am still having a problem and with a missing range error.

The code now looks like the following:

(Current Data Table() << Data Filter(
Mode( Show( 1 ), Include( 1 ) ),
Inverse( 0 ),
invisible,
Add Filter(
    columns(:Fine),
     Where(: Fine =={0,1}))));

an error says that the range is missing. Is there a function where I can set the range of a Column or Variable?

I have listed all of my columns in the "Columns" element and I have "Where" statements separate for all of my columns that I want to filter out.