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: 
Not applicable

Disable selections for other tabs

I am working on KPI's report that does not use the same selection fields on all of the tabs (worksheets).

For example - date selections are only necessary on the first tab but not on the rest of them.

What is the function that i would need to use to specify where and how to use which selections? ,

Thank you for your help!

3 Replies
mato32188
Specialist
Specialist

Hi Zhenya,

in your expression use Set Analysis like sum( {<Field1 = >} Sales) = lets say, it would not react on your Field1 selection...

M

ECG line chart is the most important visualization in your life.
Not applicable
Author

Hi,


Use Set analysis as @martin has suggested..It will make charts independent from user selections.

Colin-Albert

Set Analysis changes how any selections are applied to an expression.

sum({1} Amount) will ignore all selections.

sum({1 <Region = {'USA'}>} Amount)  will give the total for USA ignoring all other selections.

sum({1 <Region = {'USA'}, Year={2014}>} Amount) will give the total for USA & 2014, ignoring all other selections.

 

I would suggest using the {1} set for your KPI expressions and add any specific filters as set modifiers to the expressions.