topic Filter only one Chart in QlikView

Filter only one Chart

vinicius_siquei — Sat, 18 Jan 2014 14:30:57 GMT

Folks,

One of the filters avaliable in my dashboard must filter only one chart. The user doesn't want to see its effect over the others elements in the dashboard.

Is it possible ?

Thanks.

Vinicius

Re: Filter only one Chart

MK_QSL — Sat, 18 Jan 2014 15:20:12 GMT

Don't understand your question properly... Do you want to enable/disable some chart based on some filter?

Re: Filter only one Chart

vinicius_siquei — Sat, 18 Jan 2014 15:23:50 GMT

Actually not.

What I want to do is when the user select one of the values available in filter box, it should only filter the data in one specific chart. All the other charts/tables on the dashboard souldn't be affected by this selection.

Is it possible to do ?

Thanks for your help.

Re: Filter only one Chart

MK_QSL — Sat, 18 Jan 2014 15:30:49 GMT

You need to create an alternate state

List box/filter box should be in that alternate state

and your data table which you want to change should be either in that alternate state or you need to use set analysis

Re: Filter only one Chart

Anonymous — Sat, 18 Jan 2014 15:31:00 GMT

Vinicius

Have you looked at using Alternate States ?

This document Why Comparative Analysis - Technical Brief.pdf gives an explanation of it.

Best Regards, Bill

Re: Filter only one Chart

Anonymous — Sat, 18 Jan 2014 15:32:04 GMT

Vinicius

Have you looked at using Alternate States ?

Best Regards, Bill

Re: Filter only one Chart

sebastiandperei — Sat, 18 Jan 2014 15:39:52 GMT

You Should use Alternate States, like Bill and Manish says. In help you will get information about how it works.

We can help you in this work, but you should send a sample qvw.

Re: Filter only one Chart

santharubban — Mon, 20 Jan 2014 21:45:37 GMT

Hi Vinicius,

Try this

sum( {$<Module=,HourRange = {0}>} TransferCount)

i think it will help you, if not upload the expression.

Re: Filter only one Chart

Clever_Anjos — Tue, 21 Jan 2014 00:12:59 GMT

Vinicius,

Put an set analysis into all graphs that does not have to be filtered

sum({<Dim1=>}value) // Dim1 will not affect this expression

Re: Filter only one Chart

vijetas42 — Mon, 14 Apr 2014 05:37:13 GMT

You can use Alternate state form Settings->Document Properties create 2 alternate states one for your filter & another one for chart and accordingly on your list boxes and charts you can use state whichever you have created

Regards,

Vijeta

Re: Filter only one Chart

rajat2392 — Mon, 14 Apr 2014 07:28:57 GMT

no need to use any alternate state, just add this expression in the charts in which you don't want the change..

sum({1}your_fieldname)

It will ignore all the filter selection, so apply this on all the charts where you don't want to see the change.

If you want to ignore only some filters selection shouldn't create any change, then write this expression...

sum({<filter1=, filter2=>}your_fieldname)

Re: Filter only one Chart

rustyfishbones — Mon, 14 Apr 2014 07:33:37 GMT

You can use Alternate States for this

There are some good videos on Youtube to show you this

Regards

Alan

Re: Filter only one Chart

nizamsha — Mon, 14 Apr 2014 07:53:34 GMT

use Alternate State when u use Alternate state in specific chart that char only changes other chart wont get affected

Setting ->Document Properties->General->Alternate State.>Give Alternate State Name -.>

Finally give the Alternate State in the list box what u like -->

listbox>genereal->alternate State->alternate state name->in the chart also give the alternate state name->finally bring the alternate state name in ur expression

Re: Filter only one Chart

ThornOfCrowns — Mon, 14 Apr 2014 08:27:21 GMT

All this talk of Alternate States assumes that OP is using QV11, of course!