topic Set Analysis - Bookmark in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315817#M116514 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use the bookmarks in set anlaysis like below</P><P></P><P><SPAN style="font-weight: bold;">=Sum(</SPAN> {($ + MyBookMark)} Price<SPAN style="font-weight: bold;">)</SPAN></P><P></P><P><SPAN style="font-weight: bold;">Regards,</SPAN></P><P><SPAN style="font-weight: bold;">Jagan.<BR /></SPAN></P></BODY></HTML> Mon, 30 Jan 2012 05:42:54 GMT jagan 2012-01-30T05:42:54Z Set Analysis - Bookmark https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315816#M116513 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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?</P><P></P><P>Thanks,</P><P>Przemek</P></BODY></HTML> Sun, 29 Jan 2012 22:04:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315816#M116513 2012-01-29T22:04:12Z Set Analysis - Bookmark https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315817#M116514 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use the bookmarks in set anlaysis like below</P><P></P><P><SPAN style="font-weight: bold;">=Sum(</SPAN> {($ + MyBookMark)} Price<SPAN style="font-weight: bold;">)</SPAN></P><P></P><P><SPAN style="font-weight: bold;">Regards,</SPAN></P><P><SPAN style="font-weight: bold;">Jagan.<BR /></SPAN></P></BODY></HTML> Mon, 30 Jan 2012 05:42:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315817#M116514 jagan 2012-01-30T05:42:54Z Re: Set Analysis - Bookmark https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315818#M116515 <HTML><HEAD></HEAD><BODY><P>Found it in the manual - {$*BM}! Sorry for bothering.</P></BODY></HTML> Mon, 30 Jan 2012 07:19:30 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315818#M116515 2012-01-30T07:19:30Z Set Analysis - Bookmark https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315819#M116516 <HTML><HEAD></HEAD><BODY><P> You can use the Set Analysis Wizard, There you will find how to set the calculation</P><P>based on the intersection between the current selection and the bookmark </P><P>This is what you get : Sum({$*BM01}Price)</P><P></P><P>If you want to explore more you will find the Wizard here:</P><P><A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx">http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx</A></P></BODY></HTML> Mon, 30 Jan 2012 07:38:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315819#M116516 orital81 2012-01-30T07:38:13Z Set Analysis - Bookmark https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315820#M116517 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this </P><P></P><P><SPAN class="Bold">=Sum(</SPAN> {$&lt;Rep= P({RepBookmark} Rep)&gt;} Price * ProductQty<SPAN class="Bold">)</SPAN><SPAN style="margin-left: 40px;"><BR /></SPAN></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 30 Jan 2012 07:52:02 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Bookmark/m-p/315820#M116517 jagan 2012-01-30T07:52:02Z