topic Re: exclude chart from filter? in QlikView

exclude chart from filter?

Thu, 23 Jun 2011 07:17:41 GMT

Hello,

I have two charts which are fetching data from the same table. With one chart, I am selecting only one week, while with the other chart, i am selecting all weeks. There are some other filters that are same to both charts.

Now how can i make them both so that when i select the week filter, only one chart is effected, while with other filters, both chart should be effected

Arif

exclude chart from filter?

matt_crowther — Thu, 23 Jun 2011 07:52:20 GMT

Either detach the chart before making the selections or use Set Analysis in the chart expression(s).

Search the Help file for further info.

Hope that helps,

Matt - Visual Analytics Ltd

exclude chart from filter?

Thu, 23 Jun 2011 07:54:03 GMT

Hello,

Thanks for the reply. Can you give a short example of how to use set analysis for this purpose?

Arif

Re: exclude chart from filter?

kaushiknsolanki — Thu, 23 Jun 2011 08:15:42 GMT

Hi,

Here is an example.

Regards,

Kaushik Solanki

Re: exclude chart from filter?

Thu, 23 Jun 2011 08:43:08 GMT

Thanks. It is working. Now in the attached example, if I want both tables to be effected by the invoice id filter, then how can i change this expression. Currently, the table which says, set analysis, is not effected by date, which is exactly what i want...but it is also not being effected by invoice id, but i want it to be effected by invoice id filter. only the date should be excluded. how can i change it then?

Arif

Re: exclude chart from filter?

Thu, 23 Jun 2011 08:50:09 GMT

also, you have enter your expression like

Sum ({1}Value). What does this 1 represent here?

Arif

Re: exclude chart from filter?

kaushiknsolanki — Thu, 23 Jun 2011 09:14:45 GMT

Hi,

Checkout this example.

{1} - means show all values - regardless of selections.

Regards,

Kaushik Solanki

Re: exclude chart from filter?

Thu, 23 Jun 2011 10:29:29 GMT

Hello,

Thanks a lot. this is really what i wanted. Actually i am totally new to set analysis and am using it for first time. Now here is one small modification. I have a count like this

sum(if([item confirmation]='False',Items)

and the same expression i want to use using set analysis, and want to excluse the date from filter, as you did in the example, then what will be the expression for set analysis for the above expression.

What i mean to say is how can we add the condition ([item confirmation]='False' to the below set analysis expression

Sum ({$<Date1=>}Value)

Arif

Re: exclude chart from filter?

kaushiknsolanki — Thu, 23 Jun 2011 10:35:43 GMT

Hi,

Try

sum({<Item Confirmation = {"False"},Date1=>}Values)

Regards,

Kaushik Solanki

Re: exclude chart from filter?

Thu, 23 Jun 2011 11:00:26 GMT

Perfect. That is what i wanted.

Thanks

Arif