topic Re: Difference Between Set Analysis and Alternate states? in QlikView

Difference Between Set Analysis and Alternate states?

Anonymous — Sun, 06 Jul 2014 14:04:02 GMT

Hi To Every One........

Can You Please clarify me Difference between set analysis and Alternate states.....Actually i am little bit confusion about that..............

Re: Difference Between Set Analysis and Alternate states?

swuehl — Sun, 06 Jul 2014 16:04:31 GMT

There was a similar request just recently:

Set analysis vs Alternate state

Re: Difference Between Set Analysis and Alternate states?

Sun, 06 Jul 2014 17:05:02 GMT

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.

Re: Difference Between Set Analysis and Alternate states?

Anonymous — Tue, 08 Jul 2014 16:11:53 GMT

Hi Nuthankumar.........

Thanks for your replay...........

The purpose of alternate states and set analysis is provides the comparative analysis for Qv Objects.Alternate states is better so why we go for set analysis................and what are the major difference between them....Can you please help me.........

Re: Difference Between Set Analysis and Alternate states?

Tue, 08 Jul 2014 16:38:25 GMT

Hi,

The purpose of alternate states and set analysis is not the same. They are different.

Alternate states is used for comparative analysis. The Qv designer can create multiple states within a Qv document and apply these states to specific objects. Now the objects which are assigned particular states, that object will respond to user selections which are made in that particular state only.

And about set analysis. Set analysis allows you to define exactly which data we would like the expression to use.

For example:

=Sum({$<Country={'USA'}>}LineSalesAmount)

Here we have specified USA as a country which means your chart should use USA only. If you select country UK or any other. the chart will not respond to user selection rather it will display values related USA itself.

Re: Difference Between Set Analysis and Alternate states?

Anonymous — Tue, 08 Jul 2014 16:46:29 GMT

Hi sowmya..........

Thanx for your explanation.Now i get clear clarification.........

And One more Question Can you Give me the some of optimized Techniques for Qlikview project Development(Dash board design,memory Savings........) with some explanations?

Re: Difference Between Set Analysis and Alternate states?

Wed, 09 Jul 2014 16:57:13 GMT

Hi,

The various methods for optimized load are:

Try to create QVD files. By creating QVD files u can have 90% compressed data of original one

which can save lot of memory.

Eliminate if statements as much as possible, instead u can use flags.

Don't write complex expressions at the front end, try to write more script at the back end.

And avoid synthetic keys by creating link tables or by renaming the fields.

Re: Difference Between Set Analysis and Alternate states?

engishfaque — Wed, 09 Jul 2014 18:39:51 GMT

Dear Chandini,

Set Analysis

Defining a set of field values is referred to as defining a set expression and using set expressions to analyze data is referred to as set analysis.

Alternate States

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.

Key point: Alternate States functionality is not accessible in the load script.

Kind regards,

Ishfaque Ahmed

Re: Difference Between Set Analysis and Alternate states?

Anonymous — Thu, 10 Jul 2014 18:01:06 GMT

Hi....

How we can eliminate if statements instead using of Flags?Can you explain with example?

Re: Difference Between Set Analysis and Alternate states?

vardhancse — Thu, 10 Jul 2014 18:08:41 GMT

Set Analysis:

Is used to write expressions for the metrics

There will be some conditions based on that we can write the set analysis:

Set analysis will not work in the script level

It will work only in the chart expression,list box simply to say only in the fornt end UI objects

Alternate States:

Alternate state is the option in QV:

We can do comparitive analysis

the selections we do will pass only to the objects of same alternate states