topic Filter in script in QlikView

Filter in script

Anonymous — Tue, 25 Apr 2017 11:40:15 GMT

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

Re: Filter in script

prma7799 — Tue, 25 Apr 2017 11:48:31 GMT

Try this???

there is other way to do it...

Re: Filter in script

Anil_Babu_Samineni — Tue, 25 Apr 2017 11:49:41 GMT

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

Re: Filter in script

maxgro — Tue, 25 Apr 2017 11:50:58 GMT

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

;

Re: Filter in script

Anonymous — Tue, 25 Apr 2017 12:26:03 GMT

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

Re: Filter in script

Anonymous — Tue, 25 Apr 2017 12:37:40 GMT

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

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

Re: Filter in script

prma7799 — Tue, 25 Apr 2017 12:43:42 GMT

What is your expected output...

Re: Filter in script

prma7799 — Tue, 25 Apr 2017 12:44:34 GMT

Try this .....

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

Re: Filter in script

vinieme12 — Tue, 25 Apr 2017 12:48:48 GMT

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))

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

Re: Filter in script

maxgro — Tue, 25 Apr 2017 13:22:24 GMT

add a NOT to my previous answer

Where

NOT (

Question = 'Feedback'

AND len(trim(Answer)) = 0

)

;