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: 
mmarchese
Creator II
Creator II

Apply set analysis to an entire sheet?

Is this possible?  For instance, rather than having to add {<[Machine Type]={'Sorter'}>} to every single measure on my "Sorting Machines" sheet, it'd be really convenient to add it once at the sheet level, allowing me to keep my individual measures simple.

1 Reply
mmarchese
Creator II
Creator II
Author

I figured out a way to accomplish this via an extension.  I'd rather not resort to it though, since this extension -- like many extensions -- seems buggy and -- like all extensions -- takes up space on the sheet and doesn't work in the cloud.

Anyway, here's how to implement it:

  1. Get the SheetEvents extension, which lets you execute actions upon switching to a certain sheet.
  2. Replace the hard-coded filters in each of your measures with a reference to a variable.  So instead of {<[Machine Type]={'Sorter'}>}, you'd just have {$(v_sheetFilter)}.
  3. Use SheetEvents to do two actions upon switching to the sheet in question:
    1. Clear selection filters as needed.  In this case, I'd clear any filters on [Machine Type].
    2. Set v_sheetFilter = "<[Machine Type]={'Sorter'}>"