topic Re: question on trapping previous selection values in QlikView

question on trapping previous selection values

gerrycastellino — Tue, 07 Jun 2016 16:13:33 GMT

Count(DISTINCT {$1} KPI)

The above expression will display the values of KPI from the previous selections that were made.

Is there a way to retrieve the values of those selections ? as in what shows in the 'Current Selections' box.

Re: question on trapping previous selection values

sunny_talwar — Tue, 07 Jun 2016 16:14:57 GMT

May be capture this in an alternative to Current Selections object:

Current Selection Alternatives

Re: question on trapping previous selection values

gerrycastellino — Tue, 07 Jun 2016 16:28:21 GMT

Sunny: not what I need - I need to find a way to go back in time to the previous selection and grab those values - if possibly they are stored somewhere.

Re: question on trapping previous selection values

sunny_talwar — Tue, 07 Jun 2016 16:32:25 GMT

May be like this:

Are there particular fields you are looking for? or it could be any selection? For particular object you can try this:

Concat(DISTINCT {$1} FieldName1, ', ')

Re: question on trapping previous selection values

gerrycastellino — Tue, 07 Jun 2016 16:38:16 GMT

this may have to work then - would be perfect if it could be done like this:

getcurrentselections($1)

Re: question on trapping previous selection values

sunny_talwar — Tue, 07 Jun 2016 16:41:05 GMT

I agree, but sometimes its all about best alternative, I guess