topic Previous selection in QlikView

Previous selection

Wed, 27 May 2015 11:35:08 GMT

Hi,

i know the statement getcurrentselection() ... But is it possible to get something like "getPREVIOSselection()" ???

Thank you

Re: Previous selection

jonathandienst — Wed, 27 May 2015 11:38:23 GMT

No function like that, but the set expression selection $1 uses the previous selection, for example

Sum({$1} Sales)

Re: Previous selection

jonathandienst — Wed, 27 May 2015 11:39:18 GMT

Try that with the concat statement

Concat({$1} Distinct Year, ', ')

Re: Previous selection

Wed, 27 May 2015 11:39:33 GMT

I need the previous selction about everything...

Re: Previous selection

jonathandienst — Wed, 27 May 2015 11:42:56 GMT

No easy way to do that, because there is no built in statement. You may not need everything, just the usual selection fields in your model, and you can combine muliple Concat() statements

Concat({$1} Distinct Year, ', ') & '; ' & Concat({$1} Distinct Month, ', ') & .....