topic Re: Set analysis vs Alternate state in QlikView

Set analysis vs Alternate state

deepakqlikview_123 — Fri, 13 Jun 2014 12:02:14 GMT

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

Re: Set analysis vs Alternate state

datanibbler — Fri, 13 Jun 2014 12:12:31 GMT

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

Re: Set analysis vs Alternate state

eduardo_sommer — Sat, 14 Jun 2014 01:52:57 GMT

Hi Deepak,

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

Eduardo

Re: Set analysis vs Alternate state

swuehl — Sat, 14 Jun 2014 08:35:46 GMT

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.

Re: Set analysis vs Alternate state

maxgro — Sun, 15 Jun 2014 00:28:05 GMT

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)

Re: Set analysis vs Alternate state

Anonymous — Sun, 15 Jun 2014 13:10:24 GMT

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

Re: Set analysis vs Alternate state

deepakqlikview_123 — Mon, 16 Jun 2014 04:31:47 GMT

Thanks Nitha,

This info is very helpful for me

Re: Set analysis vs Alternate state

rwunderlich — Tue, 08 Jul 2014 21:38:28 GMT

Alternate States is Set Analysis for Objects.

Set Analysis is Alternate States for Expressions.

-Rob