topic Re: Filter values on different sheets in QlikView

Filter values on different sheets

Fri, 26 Apr 2013 18:38:47 GMT

Hi -

I am working with a single data source but two worksheets.

How can I dipslay the opposite entries on the two separate worksheets (Tab 1 - Closed tickets and Tab 2 - Open tickets). It seems that the filter (status=closed) aplies to both worksheets, how can i separate the two? Is that possible?

Thank you for your help!

Re: Filter values on different sheets

nilesh_gangurde — Fri, 26 Apr 2013 19:11:12 GMT

hiii zvirina123

this can be done but its tricky.

you need to create two data islands ( dataisland for tab 1 and dataisland for tab 2) which will have the field ticket with values open and closed.

then modify your tab1 charts expression in such a way that the value of open and closed will pass through the selection made in the data islands 1.

and the same way for second.

-Nilesh

Re: Filter values on different sheets

Mon, 29 Apr 2013 13:08:38 GMT

Hi Nilesh,

What do you mean when you say data islands?

Thank you

Re: Filter values on different sheets

kaushiknsolanki — Mon, 29 Apr 2013 13:22:50 GMT

Hi,

It will be best if you share the data with us. That will give us more clarification about what you have and what you want.

Regards,

Kaushik Solanki