Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How much bookmarks do you want to precess ?
The number of bookmarks is dynamic.
Sample app uploaded
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
That's right
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
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!
Thanks for all the help guys!
You're welcome mate. It was interesting problem to solve and I love these kind of challenges.
Cheers,
DV
www.QlikShare.com
Thanks again.