topic Re: Alternate states with set analysis in QlikView

Alternate states with set analysis

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Alternate states with set analysis

MK_QSL — Wed, 25 Apr 2018 14:07:37 GMT

Is possible to use alternate States with set analysis

Alternate state in set analysis

Re: Alternate states with set analysis

sunny_talwar — Wed, 25 Apr 2018 14:08:05 GMT

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))"}>}

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

Re: Alternate states with set analysis

manu1512 — Wed, 25 Apr 2018 14:15:10 GMT

Hi Sunny,

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

Regards

Manu

Re: Alternate states with set analysis

sunny_talwar — Wed, 25 Apr 2018 14:20:37 GMT

You sure can

Re: Alternate states with set analysis

manu1512 — Wed, 25 Apr 2018 14:29:12 GMT

if possible can you let me know how to do this

Re: Alternate states with set analysis

sunny_talwar — Wed, 25 Apr 2018 14:32:08 GMT

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?

Re: Alternate states with set analysis

bc-thebruuu — Wed, 25 Apr 2018 14:43:59 GMT

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

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