Current Selections for Bookmarks

[Anonymous]

Hi - I have a file which has two graphs linked to to two different bookmarks.

The file allows the user to make selections, then set the bookmarks so that they compare two different selections.

I want to show what the user has selected  for both bookmarks- so ideally a current selections box based on a bookmark.

Any suggestions??

[Jason_Michaelides]

Maybe something using Concat() and set analysis?  I can't test this right now but:

Concat({BM01}  If(GetSelectedCount($Field)>0,$Field),', ')

Really not sure if it'll work!

Hope this helps,

Jason

[Anonymous]

I have used the below - which is ok, although it creates some annoying formatting problem when i put it into a pivot chart.

I could put it in a text box but it doesn't look as neat.

I was just wondering if there was an easy way of re creating what the current selections box does.

=If(count({1}  total distinct DIM_PROPOSITION) =  count({BM02} distinct DIM_PROPOSITION), 'ALL',concat({BM02} distinct DIM_PROPOSITION, ', '))

[Jason_Michaelides]

Something similar came up a little while ago...check out Stefan's (sweuhl) post in this thread:

http://community.qlik.com/thread/50720

[Jason_Michaelides]

(obviously add your bookmark {BM02} into his Concat() statement)

[Anonymous]

Thanks - this looks like something i can use, my current approach wouldn't deal with any new fileds whereas this would.

[Jason_Michaelides]

Jolly good 🙂