Set Analysis - Bookmark

[#1]

Hi All,

I've got a tabe of three dims: Rep. Product, Price. I've created a bookmark which selects a group of sales reps. How can I put the bm into a set expression to keep expression being affected by selection of other two dimesions?

Thanks,

Przemek

[jagan]

Hi,

You can use the bookmarks in set anlaysis like below

=Sum( {($ + MyBookMark)} Price)

Regards,

Jagan.

[#3]

Found it in the manual - {$*BM}! Sorry for bothering.

[orital81 · Accepted solution]

You can use the Set Analysis Wizard, There you will find how to set the calculation

based on the intersection between the current selection and the bookmark

This is what you get : Sum({$*BM01}Price)

If you want to explore more you will find the Wizard here:

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

[jagan]

Hi,

Try this

=Sum( {$<Rep= P({RepBookmark} Rep)>} Price * ProductQty)

Regards,

Jagan.