Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gerrycastellino
Contributor III

question on trapping previous selection values

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.

Tags (1)
1 Solution

Accepted Solutions

Re: question on trapping previous selection values

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, ', ')

5 Replies

Re: question on trapping previous selection values

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

Current Selection Alternatives

gerrycastellino
Contributor III

Re: question on trapping previous selection values

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

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, ', ')

gerrycastellino
Contributor III

Re: question on trapping previous selection values

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

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