Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Alternate states with set analysis

Hi all,

Can any one help me please how to use alternate state with set analysis.

I was asked this question in interview

Regards

Manu

7 Replies
Highlighted
MVP
MVP

Re: Alternate states with set analysis

Highlighted

Re: Alternate states with set analysis

Just like you would use in inherited state.... I don't think there is any difference except the fact that it is in the alternate state

Default State

{$<Year = {"$(=Max(Year))"}>}

Alternate State (AS)

{[AS]<Year = {"$(=Max(Year))"}>}

or

{[AS]<Year = {"$(=Max({[AS]}Year))"}>}

Highlighted
Creator
Creator

Re: Alternate states with set analysis

Hi Sunny,

Can we reflect changes in the chart having in different state with the list box having different state?

Regards

Manu

Highlighted

Re: Alternate states with set analysis

You sure can

Highlighted
Creator
Creator

Re: Alternate states with set analysis

if possible can you let me know how to do this

Highlighted

Re: Alternate states with set analysis

Sure thing... would you be able to provide a sample or some sample data and explain what exactly you want to make selection on and where should it be making an impact?

Highlighted
Creator
Creator

Re: Alternate states with set analysis

2 way to do it:

chart object is related to the alternate state

and expressions do not make any reference to a specific alternate state

OR

in the expression, you use alternate state as per Talwar example