Survey answers "yes/no" but on QV screen select the column headline

[#1]

Hello,

I guess my question is easy to answer but after hours searching in the discussions I could not find a solution.

Maybe the main reason is, that I do not use the right keywords but I'm sure someone could answer my question.

I made a survey e.g. for suppliers and ask them if they have a certification (Answer is "yes" or "blank" if no). In Qlikview I want to have now the column headline as "buttons" and if I click on them the suppliers should appear in a list.

For example in the excel attached I would have in QVthe buttons:

Group for certificates: ISO9001;ISO14001;ISO18001

Group for portfolio: Portfolio 1, Portfolio 2, Portfolio 3

And blow a list with the supplier names.

So if I would click now in QV on "ISO9001" (not the content "yes" or "no") only supplier "Supplier ABC" should appear in the list.

Thanks for support.

Regards

Dennis

[Anonymous · Accepted solution]

Hi!

Take a look on the attached file.

Regards,

Gabriel

[carvalguil]

Or something like this:

[#4]

Dear Gabriel and Guilherme,

both answers were helping me a lot, thanks for that.

With the solutions I now have figured out an other issue.

If I would like to find a supplier which has ISO14001 and ISO18001 (not or as qlikview is doing it) then the expected result should be  "Supplier DEF" only.

But I'm sure this issue I will find somewhere in an discussion.

Have a good weekend.

Best Regards

Dennis