topic Set analysis previous selection in alternate state. in QlikView

Set analysis previous selection in alternate state.

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

Hello,

I am successfully using expression=Count({$1-$}1) to list records that were dropped after last selection in straight table chart.

I am having trouble to implement this in an alternate state.

My alternate state is named MF.

I tried:

=Count({$1-MF}1)

=Count({MF1-MF}1)

=Count({MF$1-MF}1)

none of which seem to work.

Has anyone tackled similar issue?

Kind regards,

Marek

Re: Set analysis previous selection in alternate state.

trdandamudi — Mon, 18 Sep 2017 20:05:29 GMT

May be like below:

=Count({$1-$::MF}1)

Re: Set analysis previous selection in alternate state.

ramasaisaksoft — Tue, 19 Sep 2017 07:12:28 GMT

check like this

Count ({[MF]<$1-$>}1)

ex:-

the SUM of Sales for the previous year in a straight table. The straight table has the alternate state "Group 3", thus I formulated the expression as follows:

Sum( {[Group 3]<Year = { $(=max(Year)-1)}>} Sales )

Re: Set analysis previous selection in alternate state.

marunio007 — Tue, 19 Sep 2017 13:46:39 GMT

Thank you for both attempts but your suggested solutions do not work.

I guess my post is more about a general question: is there a reference to a previous selection in an alternate state ? If yes, what is the syntax?

Re: Set analysis previous selection in alternate state.

Anonymous — Wed, 10 Oct 2018 15:22:20 GMT

Not sure if you got the answer but MF::$1 will give you the previous selections in MF alternate state