topic Re: Detached in Set Analysis in QlikView

Detached in Set Analysis

saumyashah90 — Thu, 06 Mar 2014 07:58:06 GMT

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

Re: Detached in Set Analysis

Thu, 06 Mar 2014 08:05:37 GMT

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

Re: Detached in Set Analysis

saumyashah90 — Thu, 06 Mar 2014 08:08:13 GMT

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

Can you please help me in that

Re: Detached in Set Analysis

Thu, 06 Mar 2014 08:12:23 GMT

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