topic Current Selections for Bookmarks in QlikView

Current Selections for Bookmarks

Anonymous — Mon, 14 May 2012 13:55:13 GMT

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 — Mon, 14 May 2012 14:13:45 GMT

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 — Mon, 14 May 2012 14:21:26 GMT

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 — Mon, 14 May 2012 14:28:51 GMT

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

Jason_Michaelides — Mon, 14 May 2012 14:29:26 GMT

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

Anonymous — Mon, 14 May 2012 14:37:49 GMT

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

Jason_Michaelides — Mon, 14 May 2012 14:44:25 GMT

Jolly good 🙂