topic Re: Selection based on some predefined keywords in QlikView

Selection based on some predefined keywords

Thu, 18 Sep 2014 14:08:11 GMT

Hello,

I have a table that contains new-products and its reviews by a set of product users. Please see attached picture Table1.png.

Requirement is to create a hard-coded list box of Positive, Negative and Neutral "Review types". Please see attached picture Review_filter.png

And when I select any 'review type' from the list box, lets say 'Good', the output I should get as a filtered table in attached picture 'Result.png', because, these rows contain 'good' as a comment by at least one of the reviewer.

I want to achieve something like -"Search and Filter".

I hope my requirements are clear. Please help me in achieving this.

Thanks in advance.

Re: Selection based on some predefined keywords

JonnyPoole — Thu, 18 Sep 2014 15:40:40 GMT

Here is a sample with your sample data. The load could be streamlined further in case you had more than 4 reviewers.

With a couple more steps, not hard, you can get condtional background colors and a hierarchical text box too.

Let me know if this is helpful

Re: Selection based on some predefined keywords

Tue, 23 Sep 2014 12:06:44 GMT

Thanks a ton Jonathan Poole !!