Bookmark in set analysis from variable

[#1]

Ok, so I have a expression like so

=Sum({$<

[Organisational Unit]=P({BK1}[Organisational Unit])

>} [measure])

This works great.

Now what I want to do is to pick up the bookmark name from a variable so I can use this in a chart table with a calculated dimension that pulls the bookmark names.

I have tried everything I can think of to no avail, could someone help point me in the right direction?

Thanks

Message was edited by: Chris Cooil

[whiteline]

How much bookmarks do you want to precess ?

[#3]

The number of bookmarks is dynamic.

[#4]

Sample app uploaded

[IAMDV]

Chris - Quick question. Do you want to Sum(FTE) for each bookmark. Is this right? I wanted to fully understand your requirements before attempting to solve this one.

Thanks,

DV

[#6]

That's right

[IAMDV]

Hi Chris,

I've got it working with 2 variables and 2 expressions. See the attachment and let me know if this is what you wanted.

I can explain in-detail if you don't follow it completely. I've tested by adding new bookmark and it works fine.

Cheers,

DV

www.QlikShare.com

[#8]

This works well, thanks so much.

I've tweaked it a bit so that that only the orgunit field is using the bookmarks (using P)

but this approach was an innovative way of doing it.

Thanks again!

[#9]

Thanks for all the help guys!

[IAMDV]

You're welcome mate. It was interesting problem to solve and I love these kind of challenges.

Cheers,

DV

www.QlikShare.com

[#11]

Thanks again.