Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

what is difference between set analysis and alternative states in qlikview?

hi friends in qlikview what is difference between set analysis and alternative states in qlikview when are we using in qlikview and can you please any one send me with examples .   about set analysis and alternative states 

4 Replies

Re: what is difference between set analysis and alternative states in qlikview?

The sets analysis let you create a different selection than the active one being used into the chart or table

Please see attached file

Whereas Alternate is a another condition of object,

You can have 2 chart and two list box.

If you assign State1 to one set o chart+listbox, when you make selection in listbox only this chart that have the same state will respond to that selection.

As you see the chart and box on the left in in State1 the chart and box on the right in State2.

To create new State go to

Settings-->

Document Properties-->..

Where to find object State

Not applicable

Re: what is difference between set analysis and alternative states in qlikview?

Hi,

Set analysis is a kind of presentation of values based on the condition.

for example:sum({<Department= {'Technical'}>}sales)

here we are getting total sum of sales from technical department

BUT

Alternate states are concept of comparative analysis to compare two terms

for example i want to compare data of two departments then ill create two states and ill write as follows

sum({<Department= {'Technical'}>}sales)........state 1


sum({<Department= {'HR'}>}sales).............state2

Not applicable

Re: what is difference between set analysis and alternative states in qlikview?

Hi Subbu,

The following are some scenarios where a developer may wish to use Set Analysis:-

  • To compare results for two different time periods in one single view based on the same selection state
  • To restrict or exclude certain value(s) in a field from the calculation
  • To create a cumulative sum or YTD (Year-To-Date) result, even if the user selects only one month
  • To disregard selections in a certain field that may not be applicable to calculate a particular metric
  • To use the set of data returned by a Bookmark, even when the Bookmark is not activated
  • To replace If expressions that make use of lots of hardware resources
  • To Ignore or include some or all of the current selections



Alternate States functionality will be used to define two different record sets and compare the

corresponding results side-by-side




Harsha Nandan


pratap6699
Contributor

Re: what is difference between set analysis and alternative states in qlikview?

set analysis is used for comparing the multiple expressions in a chart and alternate state is create a state and apply for multiple objects in a application those selections can't effect to the other objects.

ex:sum({<year={2014}>}sales) here displays only 2014 sales

sum({state1<year={2014}>}sales) here state1 refers the alternate state same state we can asighn for listbox when we select that listbox only this chart will be effected not effect by any other object