Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

A clarification on how does Alternate States works with Set Analysis?

Hi all,

I have the following example:

Capture.JPG

In the above example:

You can See:

List Box in StateA affects the StateA chart

List Box in StateB affects the StateB chart

List box in Inherited affects the StateA : Sum({$}Sales) chart.

(Sales by Division)

Does this mean when an object is in a particular state (e.g. StateA) but the expression has set analysis where a $ is used, the expression will ignore the state the object is in?

It seems to suggest this based on my pie chart above.

2 Replies
Anonymous
Not applicable

Hi John,

Try below syntax in  two expressions:

sum({[State A]<[Region] = $::[Region]>} Sales)

sum({[State B]<[Region] = $::[Region]>} Sales)


Regards

Neetha

avinashelite

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.