Ignore selections in a chart

[geogou1973]

Hello,

I have the following expression

sum(QTY*PAFDNA)

how can i ignore all filtering selections ;

Thank you in advance

[surendraj]

Try with

sum({1}QTY*PAFDNA)

[geogou1973]

Unfortunately does not work

[dsharmaqv · Accepted solution]

you can detach your chart

Chart Properties -> General tab -> Select Detached

or change state

http://www.qlikfix.com/2014/08/12/alternate-states/

[avinashelite]

You would set an alternate state for the same.

Go to >Document Properties>Alternate state > add a new state and use the same in the chart

Hope this helps you

Source : QlikView Reference Manual

Alternate States

Description

You can use Alternate States to perform comparative analysis between sets of multiple data items, for example for basket analysis purposes. A state holds a set of selections.

The QlikView developer can create multiple states within a QlikView document and apply these states to specific objects within the document. The end-user can create copies of these objects (server objects) and then put those objects into different states.

The most important difference between Detach and Alternate States is that ALL objects in a given state will respond to user selections made in that state. Objects in a given state are not affected by user selections in the other states.

Alternate States functionality is not accessible in the load script.

Note!
Alternate States functionality is enabled by a QlikView developer and should be used with caution as it can cause great confusion with end-users as there is no automatic on-screen indication that objects or expressions are in, or reference, alternate states. It is up to the QlikView developer to provide this information to the end-user using the StateName() function.

Setting Alternate States

Do the following to enable and set alternate states:

1. Click Alternate States... in the Document Properties: General tab.
   The Alternate States dialog opens.
2. Click Add... to create a number of states, and name them. The names will be referred to as state identifiers.
3. Click OK to close the dialog.

Now the QlikView developer can create new Alternate States from within screen objects.End-users who access QlikView documents from a QlikView Server can make use of Alternate States but cannot create Alternate States.

Assigning States to Objects

Do the following to assign a state to an object:

1. Open the Properties dialog and select the General tab.
2. Set Alternate State to the state identifier you want to use for the object.

The object will now be independent from the rest of the document in terms of selection, unless other objects are set to the same state.

There are two states that are always available; default state and inherited. The default state is the state where most QlikView usage occurs and is represented by $. The QlikView document is always in the default state. Objects can inherit states from higher level objects, such as sheets and containers. This means that states are inherited as such: Document - Sheet - Sheet Objects. The sheets and sheet objects are always in the inherited state unless overridden by the QlikView developer.

Comparing Alternate States

You can compare two states on the same object. For example, you can create a line chart to display both states of the data with the same axis by assigning a state in the expression using Set Analysis.

Example:

If you have defined the states Group1 and Group2, you can compare the average of field Adj.Close for the groups by showing these two expressions in a line chart:

Avg({[Group1]} [Adj.Close])

Avg({[Group2]} [Adj.Close])

Logical Behavior when Using Alternate States

Pressing the Clear button affects all states.
In the Inter Explorer plugin, a menu item has been added to the Clear button drop-down menu that allows a user clear the selections of a specific state. This menu is not available in the Ajax client, but the same function can be achieved by creating an action button connected to the Clear action with a specific state.

Pressing the Back and Forward buttons affects all states. There is no mechanism to move back and forward through specific states.

Pressing the Lock and Unlock buttons affects all states. It is not possible to lock and unlock specific states with these buttons. It is possible to lock specific fields in states by using the right-click menu on list boxes in a specific state.

The menu items in the Selections menu apply to all states. There is no mechanism to affect specific states in this menu.

Note!
Alternate States can be used with linked objects. The state applies to all instances of an object. Changing a state on a linked object will put the other linked objects into the same state.

Note!
Variables belong to the default state. Changes in other states will not affect variable values.

Note!
Triggers fire in all states.

Note!
Actions can be set to occur in specific states. One known exception is the Run Macro action. It can be set to run in a specific state; however macros fire in all states.

Note!
Objects that make use of a missing state (the state was removed by a developer) will revert to the default state though the Alternate State drop-down, that will display information such as:
AlternateStateName <unavailable>.

Note!
It is not possible to use chart field functions in conjunction with Alternate States as these functions do not have a set_expression parameter to set the state.

[geogou1973]

It is working when you check the Detached in General Tab

Thank you

[avinashelite]

NOTE: After the reload the detach property will get changed to attached...every time if you need the same effect you cannot go with that ..try the Alternate state that will help you 

[rahulpawarb]

Hello Geo,

Generally, Sum({1}QTY*PAFDNA) should work without any problem. BTW, where exactly you are using this expression?

Could you please share the application with sample data? This will help us to find the root cause of this issue.

Regards!

Rahul