https://community.qlik.com/t5/App-Development/Dividing-Rows-in-a-single-column-of-particular-group/m-p/2121826#M91346 <P>Hi Everyone,</P> <P>I have a requirement where i need to divide rows in a single column and obtain the following output.</P> <TABLE width="984"> <TBODY> <TR> <TD width="107">A</TD> <TD width="226">B</TD> <TD width="107">C</TD> <TD width="79">D</TD> <TD width="78">E</TD> <TD width="71">F</TD> <TD width="93">G</TD> <TD width="92">H</TD> <TD width="131">I</TD> </TR> <TR> <TD>MATERIAL CODE</TD> <TD>MATERIAL DESCRIPTION</TD> <TD>PRODUCT</TD> <TD>BUDGET RM</TD> <TD>ACTUAL RM</TD> <TD>DEL QTY</TD> <TD>YIELD BUDGET</TD> <TD>YIELD ACTUAL</TD> <TD>YIELD ACTUAL FORMULA</TD> </TR> <TR> <TD>513010006</TD> <TD>KETOCONAZOLE CRUDE</TD> <TD>KETOCONAZOLE</TD> <TD>4,323</TD> <TD>4,379</TD> <TD>50,968.000</TD> <TD>1.064</TD> <TD>1.078</TD> <TD>F3/F4</TD> </TR> <TR> <TD>513010035</TD> <TD>KETOCONAZOLE PHARMA_MEOH</TD> <TD>KETOCONAZOLE</TD> <TD>53</TD> <TD>72</TD> <TD>47,300.500</TD> <TD>1.000</TD> <TD>1.000</TD> <TD>F4/F4</TD> </TR> <TR> <TD>513052016</TD> <TD>PAROXETINE STAGE-II (DI BORANE)</TD> <TD>PAROXETINE</TD> <TD>4,778</TD> <TD>4,615</TD> <TD>14,287.200</TD> <TD>2.455</TD> <TD>0.576</TD> <TD>F5/F6</TD> </TR> <TR> <TD>513052017</TD> <TD>PAROXETINE STAGE -3A (BORANE)</TD> <TD>PAROXETINE</TD> <TD>1,327</TD> <TD>1,463</TD> <TD>24,791.750</TD> <TD>3.931</TD> <TD>4.322</TD> <TD>F6/F7</TD> </TR> <TR> <TD>513052018</TD> <TD>PAROXETINE STAGE -3B (BORANE)</TD> <TD>PAROXETINE</TD> <TD>3,270</TD> <TD>3,037</TD> <TD>5,736.820</TD> <TD>1.000</TD> <TD>1.000</TD> <TD>F7/F7</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>In this I want to obtain the output which is present in the YIELD ACTUAL Column and formula for the same is been shown in the YIELD ACTUAL FORMULA Column.</P> <P>Can anyone guide on how this can be done? Division needs to be done on the basis of PRODUCT.</P> Mon, 25 Sep 2023 07:59:55 GMT Saurabh_K14999 2023-09-25T07:59:55Z https://community.qlik.com/t5/App-Development/Dividing-Rows-in-a-single-column-of-particular-group/m-p/2121826#M91346 <P>Hi Everyone,</P> <P>I have a requirement where i need to divide rows in a single column and obtain the following output.</P> <TABLE width="984"> <TBODY> <TR> <TD width="107">A</TD> <TD width="226">B</TD> <TD width="107">C</TD> <TD width="79">D</TD> <TD width="78">E</TD> <TD width="71">F</TD> <TD width="93">G</TD> <TD width="92">H</TD> <TD width="131">I</TD> </TR> <TR> <TD>MATERIAL CODE</TD> <TD>MATERIAL DESCRIPTION</TD> <TD>PRODUCT</TD> <TD>BUDGET RM</TD> <TD>ACTUAL RM</TD> <TD>DEL QTY</TD> <TD>YIELD BUDGET</TD> <TD>YIELD ACTUAL</TD> <TD>YIELD ACTUAL FORMULA</TD> </TR> <TR> <TD>513010006</TD> <TD>KETOCONAZOLE CRUDE</TD> <TD>KETOCONAZOLE</TD> <TD>4,323</TD> <TD>4,379</TD> <TD>50,968.000</TD> <TD>1.064</TD> <TD>1.078</TD> <TD>F3/F4</TD> </TR> <TR> <TD>513010035</TD> <TD>KETOCONAZOLE PHARMA_MEOH</TD> <TD>KETOCONAZOLE</TD> <TD>53</TD> <TD>72</TD> <TD>47,300.500</TD> <TD>1.000</TD> <TD>1.000</TD> <TD>F4/F4</TD> </TR> <TR> <TD>513052016</TD> <TD>PAROXETINE STAGE-II (DI BORANE)</TD> <TD>PAROXETINE</TD> <TD>4,778</TD> <TD>4,615</TD> <TD>14,287.200</TD> <TD>2.455</TD> <TD>0.576</TD> <TD>F5/F6</TD> </TR> <TR> <TD>513052017</TD> <TD>PAROXETINE STAGE -3A (BORANE)</TD> <TD>PAROXETINE</TD> <TD>1,327</TD> <TD>1,463</TD> <TD>24,791.750</TD> <TD>3.931</TD> <TD>4.322</TD> <TD>F6/F7</TD> </TR> <TR> <TD>513052018</TD> <TD>PAROXETINE STAGE -3B (BORANE)</TD> <TD>PAROXETINE</TD> <TD>3,270</TD> <TD>3,037</TD> <TD>5,736.820</TD> <TD>1.000</TD> <TD>1.000</TD> <TD>F7/F7</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>In this I want to obtain the output which is present in the YIELD ACTUAL Column and formula for the same is been shown in the YIELD ACTUAL FORMULA Column.</P> <P>Can anyone guide on how this can be done? Division needs to be done on the basis of PRODUCT.</P> Mon, 25 Sep 2023 07:59:55 GMT https://community.qlik.com/t5/App-Development/Dividing-Rows-in-a-single-column-of-particular-group/m-p/2121826#M91346 Saurabh_K14999 2023-09-25T07:59:55Z