Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
hykal1993
New Contributor

How to exclude multiple fields using Action Button

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

Tags (1)
5 Replies
Highlighted
techvarun
Valued Contributor II

Re: How to exclude multiple fields using Action Button

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

A&B&C as Key

And exclude where Key ='NoNoNo';

Highlighted
techvarun
Valued Contributor II

Re: How to exclude multiple fields using Action Button

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

Highlighted
hykal1993
New Contributor

Re: How to exclude multiple fields using Action Button

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".

Highlighted
techvarun
Valued Contributor II

Re: How to exclude multiple fields using Action Button

Its easy to do via Script by creating a Flag.

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

Highlighted
hykal1993
New Contributor

Re: How to exclude multiple fields using Action Button

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