Discussion board where members can get started with QlikView.
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
Create a Fourth Column as a key by concatenating A, B and C
A&B&C as Key
And exclude where Key ='NoNoNo';
Or you can write a where condition as A&B&C <>'NoNoNo' this will avoid on additional Load incase of Huge Data
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".
Its easy to do via Script by creating a Flag.
Please share the scenario and sample data if you don't mind
I can't share the actual file but I can share a mocked file.