topic Re: Disable selections for other tabs in QlikView

Disable selections for other tabs

Mon, 08 Dec 2014 16:12:01 GMT

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!

mato32188 — Mon, 08 Dec 2014 16:16:40 GMT

Hi Zhenya,

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

Mon, 08 Dec 2014 16:24:53 GMT

Hi,

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

Colin-Albert — Mon, 08 Dec 2014 16:28:51 GMT

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.