topic Bookmark in set analysis in QlikView https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758587#M269957 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a bookmark with the Id BM01</P><P></P><P>I'm trying to integrate it into the following expression</P><P></P><P><SPAN style="font-size: 8pt;"> <SPAN style="font-size: 14pt;">=</SPAN></SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff; font-size: 14pt;">Count(</SPAN><SPAN style="font-size: 14pt;">{&lt;</SPAN><SPAN style="color: #800000; font-size: 14pt;">[Transaction Year]</SPAN><SPAN style="font-size: 14pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 14pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 14pt;">},Flag_Field_ID={1}&gt;} type_code) </SPAN></SPAN></P><P></P><P></P><P>I tried the following</P><P></P><P><SPAN style="font-size: 12pt;"> 1)</SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Count</SPAN><SPAN style="color: #ff0000; font-size: 12pt;">({<STRONG>$*BM01}{&lt;</STRONG></SPAN><SPAN style="color: #800000; font-size: 12pt;"><STRONG>[</STRONG>Transaction Year]</SPAN><SPAN style="font-size: 12pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 12pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 12pt;">},Flag_Field_ID={1}&gt;}transaction_type_code) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">2)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;"> =</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Count</SPAN><SPAN style="color: #ff0000; font-size: 12pt;">({<STRONG>BM01}{&lt;</STRONG></SPAN><SPAN style="color: #800000; font-size: 12pt;"><STRONG>[</STRONG>Transaction Year]</SPAN><SPAN style="font-size: 12pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 12pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 12pt;">},Flag_Field_ID={1}&gt;}transaction_type_code) </SPAN></SPAN></P><P></P><P> </P><P></P><P> </P><P></P><P> </P><P></P><P> </P><P></P><P><SPAN style="font-size: 12pt;">doesn't give the right results</SPAN></P><P></P><P></P><P></P><P></P><P></P><P>did not work <BR />Any tips on syntax ?</P></BODY></HTML> Fri, 06 Mar 2015 17:21:26 GMT Anonymous 2015-03-06T17:21:26Z Bookmark in set analysis https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758587#M269957 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a bookmark with the Id BM01</P><P></P><P>I'm trying to integrate it into the following expression</P><P></P><P><SPAN style="font-size: 8pt;"> <SPAN style="font-size: 14pt;">=</SPAN></SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff; font-size: 14pt;">Count(</SPAN><SPAN style="font-size: 14pt;">{&lt;</SPAN><SPAN style="color: #800000; font-size: 14pt;">[Transaction Year]</SPAN><SPAN style="font-size: 14pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 14pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 14pt;">},Flag_Field_ID={1}&gt;} type_code) </SPAN></SPAN></P><P></P><P></P><P>I tried the following</P><P></P><P><SPAN style="font-size: 12pt;"> 1)</SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Count</SPAN><SPAN style="color: #ff0000; font-size: 12pt;">({<STRONG>$*BM01}{&lt;</STRONG></SPAN><SPAN style="color: #800000; font-size: 12pt;"><STRONG>[</STRONG>Transaction Year]</SPAN><SPAN style="font-size: 12pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 12pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 12pt;">},Flag_Field_ID={1}&gt;}transaction_type_code) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">2)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;"> =</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Count</SPAN><SPAN style="color: #ff0000; font-size: 12pt;">({<STRONG>BM01}{&lt;</STRONG></SPAN><SPAN style="color: #800000; font-size: 12pt;"><STRONG>[</STRONG>Transaction Year]</SPAN><SPAN style="font-size: 12pt;">={</SPAN><STRONG style=": ; color: #808080; font-size: 12pt;"><EM>$(=max([Transaction Year]))</EM></STRONG><SPAN style="font-size: 12pt;">},Flag_Field_ID={1}&gt;}transaction_type_code) </SPAN></SPAN></P><P></P><P> </P><P></P><P> </P><P></P><P> </P><P></P><P> </P><P></P><P><SPAN style="font-size: 12pt;">doesn't give the right results</SPAN></P><P></P><P></P><P></P><P></P><P></P><P>did not work <BR />Any tips on syntax ?</P></BODY></HTML> Fri, 06 Mar 2015 17:21:26 GMT https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758587#M269957 Anonymous 2015-03-06T17:21:26Z Re: Bookmark in set analysis https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758588#M269958 <HTML><HEAD></HEAD><BODY><P>Use this:</P><P></P><P>count({BM01&lt;....</P></BODY></HTML> Fri, 06 Mar 2015 17:27:57 GMT https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758588#M269958 Anonymous 2015-03-06T17:27:57Z Re: Bookmark in set analysis https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758589#M269959 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Fri, 06 Mar 2015 17:54:39 GMT https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/758589#M269959 Anonymous 2015-03-06T17:54:39Z Re: Bookmark in set analysis https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/1587716#M443322 <P>Bom dia,</P><P>Sabe como fazer quando o id do bookmark possuí um hífen? (ex: bm6511-1)</P><P>&nbsp;</P><P>obrigado,</P> Mon, 03 Jun 2019 15:10:53 GMT https://community.qlik.com/t5/QlikView/Bookmark-in-set-analysis/m-p/1587716#M443322 rhpestana 2019-06-03T15:10:53Z