filtering

janardhan · ‎2012-11-01

Hi friends ,

i need to display only vlaues of A and B

i tried like this :

=if(worksoft='A' and 'B' , worksoft) , but it is not working, can anyone hlep me

jonathandienst · ‎2012-11-01

Hi

=if(worksoft='A' and worksoft='B' , worksoft)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

janardhan · ‎2012-11-01

thanks Jonathan , i have tried both , but its no use

Bill_Britt · ‎2012-11-01

Take a look at the attached.

The table I use is Alpha.

=if(concat(Alpha,';')='A;B',1,0)

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

janardhan · ‎2012-11-01

Thanks Bill , i have already done this task

Bill_Britt · ‎2012-11-01

So, can you post what you did?

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Related Topics