topic Set analysis with Alternate state in QlikView

Set analysis with Alternate state

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

hello,

I am new to alternate state in qv.Can anyone explain me pls the following expression ?

what does four dots explain?

Avg({[Group 1]<[Year] = $::[Year], [Month] = $::[Month]>} [Adj. Close])

Kind Regards

Manu

Re: Set analysis with Alternate state

pradosh_thakur — Thu, 14 Feb 2019 21:11:22 GMT

Avg({[Group 1]<[Year] = $::[Year], [Month] = $::[Month]>} [Adj. Close])

In the above expression it means that the entire expression will change when any object with state [Group1] gets selected. In simpler words the expression is in state [Group 1] But the year and Month slection will change with the selection in default state. $ means the default state. And $::Year means the value selected in the default state.

Let me know if my explanation is not clear.

Re: Set analysis with Alternate state

pradosh_thakur — Thu, 14 Feb 2019 21:13:16 GMT

Qlik help is the best guide

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20of%20Alternate%20States%20in%20Chart%20Expressions.htm