Detached in Set Analysis

[saumyashah90]

Hi I have Employee and i want to detach it after particular users filter

Total Employee is 500 for example

Once  a person opens application  OSUser() gets selected by default and data gets filtered for that user

he can see 200 Employee

now i want this to be static or detached for all other selections

I know we can use {1} but how to use it after that OS User() Selection

[#2]

I would store the result in a variable and use that variable in the set

if you want to do set also, you will need to do an intersection between the content of the variable and the extra set you want to do in a particular expression

Fabrice

[saumyashah90]

Yeah Fabrice even i thought of the same but didnt know how to proceed.

Can you please help me in that

[#4]

Oh not much time today: I will begin my work day

See a doc I have published on set analysis: http://community.qlik.com/docs/DOC-4951

You will see how to use varaibles in the sets, how to do an intersection

Yu will need to populate your variable

Good luck

Fabrice