topic Re: set analisys problem in QlikView https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649804#M1059704 <HTML><HEAD></HEAD><BODY><P>Hi Adi</P><P></P><P>Try below&nbsp; expression</P><P></P><P>Sum({&lt;BU_Year_Quarter ={"= SubField('$(=concat(distinct BU_Year_Quarter,'-',))','-',1)=BU_Year_Quarter"}&gt;}BudgetCurrentBook_UNIT)</P></BODY></HTML> Thu, 02 Oct 2014 14:13:45 GMT perumal_41 2014-10-02T14:13:45Z set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649799#M1059699 <HTML><HEAD></HEAD><BODY><P>why its not working -</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">BU_Year_Quarter</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">BudgetCurrentBook_UNIT</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">?</SPAN></P></BODY></HTML> Thu, 02 Oct 2014 13:57:37 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649799#M1059699 adiarnon 2014-10-02T13:57:37Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649800#M1059700 <HTML><HEAD></HEAD><BODY><P>try</P><P>sum({&lt;BU_Year_Quarter={"=$(=SubField......)"&gt;}BudgetCurrentV´Book_UNIT)</P></BODY></HTML> Thu, 02 Oct 2014 14:00:01 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649800#M1059700 Anonymous 2014-10-02T14:00:01Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649801#M1059701 <HTML><HEAD></HEAD><BODY><P>Hi adi,</P><P></P><P>explain little briefly&nbsp; for my understanding.</P></BODY></HTML> Thu, 02 Oct 2014 14:03:16 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649801#M1059701 perumal_41 2014-10-02T14:03:16Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649802#M1059702 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i want the sum of-<SPAN style="color: #800000; font-size: 8pt;">BudgetCurrentBook_UNIT</SPAN></P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;">when </SPAN></P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #800000; font-size: 8pt;">BU_Year_Quarter = </SPAN><SPAN style="color: #800000; font-size: 8pt;">SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)</SPAN></SPAN></P></BODY></HTML> Thu, 02 Oct 2014 14:06:33 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649802#M1059702 adiarnon 2014-10-02T14:06:33Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649803#M1059703 <HTML><HEAD></HEAD><BODY><P>tnx,</P><P></P><P>but its not working</P><P>its giving me -sum(BudgetCurrentV´Book_UNIT)</P></BODY></HTML> Thu, 02 Oct 2014 14:08:38 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649803#M1059703 adiarnon 2014-10-02T14:08:38Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649804#M1059704 <HTML><HEAD></HEAD><BODY><P>Hi Adi</P><P></P><P>Try below&nbsp; expression</P><P></P><P>Sum({&lt;BU_Year_Quarter ={"= SubField('$(=concat(distinct BU_Year_Quarter,'-',))','-',1)=BU_Year_Quarter"}&gt;}BudgetCurrentBook_UNIT)</P></BODY></HTML> Thu, 02 Oct 2014 14:13:45 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649804#M1059704 perumal_41 2014-10-02T14:13:45Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649805#M1059705 <HTML><HEAD></HEAD><BODY><P>can you test in a TextBox if the Expression subfield(..... is correct? </P></BODY></HTML> Thu, 02 Oct 2014 14:14:13 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649805#M1059705 Anonymous 2014-10-02T14:14:13Z Re: set analisys problem https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649806#M1059706 <HTML><HEAD></HEAD><BODY><P>tnx!!!!</P></BODY></HTML> Thu, 02 Oct 2014 14:16:09 GMT https://community.qlik.com/t5/QlikView/set-analisys-problem/m-p/649806#M1059706 adiarnon 2014-10-02T14:16:09Z