topic Set Analysis, make set analysis selection equal to listbox in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346040#M128006 <HTML><HEAD></HEAD><BODY><P> HI,</P><P></P><P>You can also try this code.</P><P></P><P>sum({&lt;bdg.Week=P(Week)&gt;} bdg.Budget_Marge)</P><P></P><P></P><P></P><P>Deepak</P></BODY></HTML> Mon, 11 Jun 2012 07:20:26 GMT deepakk 2012-06-11T07:20:26Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346037#M128003 <HTML><HEAD></HEAD><BODY><P>Gents,</P><P></P><P>I like to make the selection of my sum command equal to the choosen week of a listbox.</P><P></P><P>Where Week&nbsp; is the listbox field!</P><P></P><P>Therefore I made up the following set analysis command:</P><P></P><P>sum({&lt;bdg.Week={$::Week}&gt;} bdg.Budget_Marge)</P><P></P><P>somehow it doesn't work.... though no syntax error appears!</P><P></P><P>Who has got an idea???</P><P></P><P>Thx in advance!</P><P>F.</P></BODY></HTML> Mon, 11 Jun 2012 06:42:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346037#M128003 2012-06-11T06:42:06Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346038#M128004 <HTML><HEAD></HEAD><BODY><P>Hii,</P><P></P><P>not sure about your field names,could you send a sample doc?</P></BODY></HTML> Mon, 11 Jun 2012 06:48:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346038#M128004 2012-06-11T06:48:54Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346039#M128005 <HTML><HEAD></HEAD><BODY><P> I hope this code may help u..!!!</P><P></P><P>sum({&lt;Week={'$(#Vweek)'}&gt;} Data)</P><P></P><P>Vweek is a variable set as below</P><P><BR />Vweek=concat(distinct Week, ';')</P></BODY></HTML> Mon, 11 Jun 2012 07:16:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346039#M128005 2012-06-11T07:16:34Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346040#M128006 <HTML><HEAD></HEAD><BODY><P> HI,</P><P></P><P>You can also try this code.</P><P></P><P>sum({&lt;bdg.Week=P(Week)&gt;} bdg.Budget_Marge)</P><P></P><P></P><P></P><P>Deepak</P></BODY></HTML> Mon, 11 Jun 2012 07:20:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346040#M128006 deepakk 2012-06-11T07:20:26Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346041#M128007 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>thx for all&nbsp; the suggestions!</P><P></P><P>@Deepak: works fine, thx!!</P><P></P><P>What is the "P" for a command, never saw it?</P><P></P><P>cheers</P><P>F.</P></BODY></HTML> Mon, 11 Jun 2012 07:51:45 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346041#M128007 2012-06-11T07:51:45Z Set Analysis, make set analysis selection equal to listbox https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346042#M128008 <HTML><HEAD></HEAD><BODY><P> hi,</P><P></P><P>"P" means possible values. You can check the help file for set analysis. At botton they have explained about P and E</P><P>functions.</P><P></P><P></P><P></P><P>Deepak</P></BODY></HTML> Mon, 11 Jun 2012 08:07:20 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-make-set-analysis-selection-equal-to-listbox/m-p/346042#M128008 deepakk 2012-06-11T08:07:20Z