Filter in script

[Anonymous]

Morning I am trying to do the following :

I have :

Sales_Person, Question, Answer

John, Feedback,

Sarah, Quality, Positive

Ramesh, Delivery, Negative

Alfred, Feedback,

Tom, Feedback, Positive

Effectively I want to filter out in script any rows where Question = ‘Feedback’ and answer has not been filled in i.e len(answer)<1

So it should return :

Sarah, Quality, Positive

Ramesh, Delivery, Negative

Tom, Feedback, Positive

[prma7799]

Try this???

Or

there is other way to do it...

[Anil_Babu_Samineni]

May be use len(answer) >0 instead of yours

[maxgro]

load * inline

[

Sales_Person, Question, Answer

John, Feedback,

Sarah, Quality, Positive

Ramesh, Delivery, Negative

Alfred, Feedback,

Tom, Feedback, Positive

]

Where

  Question = 'Feedback'

  AND len(trim(Answer)) = 0

;

[Anonymous]

Just to be clear the requirment is * IF question = feedback AND len(answer)=0 )

[Anonymous]

I only want to filter these rows where the two conditions are met i.e ;

Question = 'Feedback' and len(answer) =0

[prma7799]

What is your expected output...

[prma7799]

Try this .....

Where len(Answer) <> 0 and Question  <> 'Feedback'

[vinieme12]

IF you want to do this in the Chart then your expression should be as below

=Count(if(Question = 'Feedback' and len(trim(answer))=0,1,0))

or

Count( {<Sales_Person={"=len(trim(Answer))=0"},Question ={'Feedback'}>}  Sales_Person)

[maxgro]

add a NOT to my previous answer

Where

NOT (

Question = 'Feedback'

  AND len(trim(Answer)) = 0

   )

;