topic Create a data set off vConcat? in QlikView https://community.qlik.com/t5/QlikView/Create-a-data-set-off-vConcat/m-p/200095#M58764 <HTML><HEAD></HEAD><BODY><P>All, I have a data set, lets call it Jan thru Dec. I have a set analysis working</P><P><I></I></P><P></P><P>{$&lt;</P><P>vPeriod = {<B><I>$(=concat(DISTINCT '"' &amp; B &amp; '"', ',' ))</I></B>} &gt;}</P><P>This allows me to have a user select "7" and you end up with the reveneu from 1-7.</P><P></P><P>What I would like is another variable that they select that automatically selects vPeriod, thus</P><P></P><P>if they select "Jul", it would than in turn know i want teh field vPeriod selected for 1-7</P><BR /><BR /> <BR /><BR /></BODY></HTML> Sat, 26 Sep 2009 07:46:43 GMT james 2009-09-26T07:46:43Z Create a data set off vConcat? https://community.qlik.com/t5/QlikView/Create-a-data-set-off-vConcat/m-p/200095#M58764 <HTML><HEAD></HEAD><BODY><P>All, I have a data set, lets call it Jan thru Dec. I have a set analysis working</P><P><I></I></P><P></P><P>{$&lt;</P><P>vPeriod = {<B><I>$(=concat(DISTINCT '"' &amp; B &amp; '"', ',' ))</I></B>} &gt;}</P><P>This allows me to have a user select "7" and you end up with the reveneu from 1-7.</P><P></P><P>What I would like is another variable that they select that automatically selects vPeriod, thus</P><P></P><P>if they select "Jul", it would than in turn know i want teh field vPeriod selected for 1-7</P><BR /><BR /> <BR /><BR /></BODY></HTML> Sat, 26 Sep 2009 07:46:43 GMT https://community.qlik.com/t5/QlikView/Create-a-data-set-off-vConcat/m-p/200095#M58764 james 2009-09-26T07:46:43Z