Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Subbu,
The following are some scenarios where a developer may wish to use Set Analysis:-
Alternate States functionality will be used to define two different record sets and compare the
corresponding results side-by-side
Harsha Nandan
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