Filtering Data With Various Parameters

[ngrunoz]

Hi All

I have   got data with various multiple parameters which are termed to be Norm or Expected which needs to be Analyzed.

Attached is a sample of data and I need to count the number of Citizens using the below Parameters.

Question	Norm
D.O.B	01/01/1990 - 31/12/2000
Family Size	Numeric
Employment Status	All Except Retired
Education Level	High School (or) Primary  (of) Both
ID	Alphanumeric
TransactionType	Credit Card (&) Cash

Your help and advice is greatly appreciated.

[ngrunoz]

My apologies maybe I expressed my requirements wrongly.

I have that data set in CSV and then I want that data to create a summary table counting number of Citrizens who fall in the criteria of the parameters below

Question	Norm
D.O.B	01/01/1990 - 31/12/2000
Family Size	Numeric
Employment Status	All Except Retired
Education Level	High School (or) Primary  (of) Both
ID	Alphanumeric
TransactionType	Credit Card (&) Cash

That for example if the question is D.O.B then it will count the number of citizen who have the response which fall in between 01/01/1990  &  31/12/2000; if the question is Employment Status then it counts all the Citizens with employment status which is not Retired ......... etc.

[Anil_Babu_Samineni · Accepted solution]

Like this? May be helps

[vishsaggi]

Seems to be a duplicate thread. Check here:

Conditional Flagging

[ngrunoz]

Is there a way of doing it in script in the event that they are a lot of conditions.

[Anil_Babu_Samineni]

But if we use The same condition in Script, May be you won't get all Question values

[ngrunoz]

thanks