Set analysis vs Alternate state

[deepakqlikview_123]

Hi All,

Can you please tell me what is difference between set analysis comparison and comparison  by using alternate state.

Moreover also suggest how to use mixture of set analysis and alternate state.

Thanks

[datanibbler]

Hi deepak,

I haven't really used alternate states yet - I would have loved to, I think they must be a really cool feature and the users would probably be quite thrilled to have this possibility - but I never had the time to try it.

From what I know, though, I would suggest that, first and foremost, the alternate_states thing is more flexible - it allows the user to independently control two sets of data, using listboxes to do so, in whichever way he/she likes.

<=> Set analysis, on the other hand, is very powerful - but you (as a developer) code it and the user uses it - in only one way, or a nr. of ways you (developer) have given him, nothing else.

There must also be drawbacks to alternate states, or else I'd see no point in having set_analysis at all - but I don't know about those as I haven't yet worked with them.

HTH

Best regards,

DataNibbler

[eduardo_sommer]

Hi Deepak,

Set analysis and alternate states are not mutually exclusive. You can have both in the same expression.

Eduardo

[swuehl]

Alternate state is in principle just a set identifier, like $, 1 or bookmark BM1, BM2. While set identifier 1, BM1, BM2 are rather static, alternate states are comparable to the default set $.

If you don't use alternate states, all charts, list boxes will refer to the default set, and selections will affect / modify the default set.

If you add an alternate state in document properties general tab, you can set in sheet / chart properties general tab this state to interact with, replacing the default set.

Until now you don't need any set expression.

But as Eduardo said, you can use set expression to have your expressions work with multiple sets, like

=sum({$*AS1} Values)

to use the intersection of default state and alternate state AS1.

[maxgro]

in your Qlik installation folder you can find some  examples

Open the Qlik doc "Whats New in QlikView11.qvw", usually in C:\Program Files\QlikView\Examples\Documents

and in tab Product Grouping you find a Comparative Analysis that uses alternate state (and set analysis)

[Anonymous · Accepted solution]

Hi Deepak,

Alternate states is used for comparative analysis of data  for different years or quarters using charts.

Selections made in one state or not reflected in another state in alternate states.

Alternate states - The Developer can create multiple states within a QlikView document and then apply these states to specific objects within the document.

Ex: - This feature can be utilized to compare multiple groups of, for example, sales.  It is also useful to compare selected products vs the rest of the products.

Set analysis is used to analyze data as whole or subset, in set analysis selections are reflected among all charts and controls in sheets.

Set analysis can be used in Alternate states.

See Comparitive Analysis

Regards

Nitha

[deepakqlikview_123]

Thanks Nitha,

This info is very helpful for me

[rwunderlich]

Alternate States is Set Analysis for Objects.

Set Analysis is Alternate States for Expressions.

J

-Rob