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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.