topic Re: How to get the previous selection in QlikView

How to get the previous selection

Tue, 10 Mar 2015 21:57:46 GMT

Hi,

Simply I have a nested data (Parent-Child mode) so I'm displaying the data for the current selection record and all related children.

However, one issue I have is I can't in my current set analysis filter statement use $1 to get the previous selection since I need to use '1' to get data beyond the current selection. So, how can I get -within my set analysis- the previous selection for a certain record (which is the ParentId of the current record) in order to pass it on and filter the data.

My current expression is something like this:

sum( {1<HID={"$(vHID)*"},CurrentLevel={'>=$(=vCurrentLevel)'}>} Amount)

And I just want to add another condition like: ParentId = Previous Selection ID.

Thanks!

Re: How to get the previous selection

Oleg_Troyansky — Tue, 10 Mar 2015 22:03:55 GMT

Try adding something like this:

ParentID = P({$1} ParentID)

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: How to get the previous selection

Tue, 10 Mar 2015 22:18:05 GMT

Thanks Oleg, how could I use the P() function in a parameter expression in order to pass the value over?

Re: How to get the previous selection

Anonymous — Tue, 10 Mar 2015 23:29:03 GMT

p() represents a set of possible values

and

$1 - Represents the previous selection

Re: How to get the previous selection

Oleg_Troyansky — Wed, 11 Mar 2015 00:26:41 GMT

Louie,

this is a Set Analysis function, not the parameter expression. Look it up in the Help article "Set Analysis".

Oleg

Re: How to get the previous selection

Wed, 11 Mar 2015 19:16:23 GMT

Thanks, how can I display the value of the P() function on my straight table? I tried to add an expression, but I couldn't! I just want to see the value of the ParentID = P({$1} ParentID) just for debugging purposes.

Re: How to get the previous selection

Oleg_Troyansky — Wed, 11 Mar 2015 22:59:02 GMT

Try this:

only({<ParentID = P({$1} ParentID) >} ParentID )