topic Re: How to exclude multiple fields using Action Button in QlikView

How to exclude multiple fields using Action Button

hykal1993 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Quick question, how do I exclude multiple fields with "No" in a set of data?

Say for example, column A, B, C and D has "Yes" and "No" value. I would like to exclude the row only if all columns show "No".

Thanks in advance

techvarun — Thu, 04 Oct 2018 05:00:51 GMT

Create a Fourth Column as a key by concatenating A, B and C

A&B&C as Key

And exclude where Key ='NoNoNo';

techvarun — Thu, 04 Oct 2018 05:05:19 GMT

Or you can write a where condition as A&B&C <>'NoNoNo' this will avoid on additional Load incase of Huge Data

hykal1993 — Thu, 04 Oct 2018 07:22:10 GMT

A,B and C is variable created from the script. Can I call them again to create another variable on top of that?

Actually, I just need a button where when I press it will exclude only rows where all A, B and C are "No".

techvarun — Thu, 04 Oct 2018 07:26:39 GMT

Its easy to do via Script by creating a Flag.

Please share the scenario and sample data if you don't mind

hykal1993 — Thu, 04 Oct 2018 07:48:36 GMT

I can't share the actual file but I can share a mocked file.