Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hykal1993
Contributor II
Contributor II

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

5 Replies
techvarun
Specialist II
Specialist II

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

A&B&C as Key

And exclude where Key ='NoNoNo';

techvarun
Specialist II
Specialist II

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

hykal1993
Contributor II
Contributor II
Author

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
Specialist II
Specialist II

Its easy to do via Script by creating a Flag.

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

hykal1993
Contributor II
Contributor II
Author

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