Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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!

Tags (1)
3 Replies
mato32188
Contributor III

Re: Disable selections for other tabs

Hi Zhenya,

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

M

Not applicable

Re: Disable selections for other tabs

Hi,


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

Re: Disable selections for other tabs

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.


Community Browser