topic Need help on Qlik Sense Transformation from below given input in App Development https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932371#M76819 <P>Hi Team,</P> <P>I have input like below.</P> <TABLE width="435px"> <TBODY> <TR> <TD width="154.438px">Metric</TD> <TD width="85.8333px">Target&nbsp;</TD> <TD width="124.792px">Description</TD> <TD width="68.9375px">Date</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">95</TD> <TD width="124.792px">T2 95% in 8 Hours</TD> <TD width="68.9375px">1.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">95</TD> <TD width="124.792px">T2 95% in 8 Hours</TD> <TD width="68.9375px">2.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">100</TD> <TD width="124.792px">T2 100% in 8 Hours</TD> <TD width="68.9375px">3.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">100</TD> <TD width="124.792px">T2 100% in 8 Hours</TD> <TD width="68.9375px">4.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">90</TD> <TD width="124.792px">T2 90% in 8 Hours</TD> <TD width="68.9375px">5.2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Output should like this:&nbsp;</P> <TABLE width="500"> <TBODY> <TR> <TD width="156">Metric</TD> <TD width="86">Target</TD> <TD width="125">Description</TD> <TD width="69">From Date</TD> <TD width="64">To Date</TD> </TR> <TR> <TD>M1</TD> <TD>95</TD> <TD>T2 95% in 8 Hours</TD> <TD>1.2022</TD> <TD>2.2022</TD> </TR> <TR> <TD>M1</TD> <TD>100</TD> <TD>T2 100% in 8 Hours</TD> <TD>3.2022</TD> <TD>4.2022</TD> </TR> <TR> <TD>M1</TD> <TD>90</TD> <TD>T2 90% in 8 Hours</TD> <TD>5.2022</TD> <TD>null</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Can you please suggest/help on how can i transform data input into output as shown above..</P> Wed, 18 May 2022 10:59:12 GMT vish123 2022-05-18T10:59:12Z Need help on Qlik Sense Transformation from below given input https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932371#M76819 <P>Hi Team,</P> <P>I have input like below.</P> <TABLE width="435px"> <TBODY> <TR> <TD width="154.438px">Metric</TD> <TD width="85.8333px">Target&nbsp;</TD> <TD width="124.792px">Description</TD> <TD width="68.9375px">Date</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">95</TD> <TD width="124.792px">T2 95% in 8 Hours</TD> <TD width="68.9375px">1.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">95</TD> <TD width="124.792px">T2 95% in 8 Hours</TD> <TD width="68.9375px">2.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">100</TD> <TD width="124.792px">T2 100% in 8 Hours</TD> <TD width="68.9375px">3.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">100</TD> <TD width="124.792px">T2 100% in 8 Hours</TD> <TD width="68.9375px">4.2022</TD> </TR> <TR> <TD width="154.438px">M1</TD> <TD width="85.8333px">90</TD> <TD width="124.792px">T2 90% in 8 Hours</TD> <TD width="68.9375px">5.2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Output should like this:&nbsp;</P> <TABLE width="500"> <TBODY> <TR> <TD width="156">Metric</TD> <TD width="86">Target</TD> <TD width="125">Description</TD> <TD width="69">From Date</TD> <TD width="64">To Date</TD> </TR> <TR> <TD>M1</TD> <TD>95</TD> <TD>T2 95% in 8 Hours</TD> <TD>1.2022</TD> <TD>2.2022</TD> </TR> <TR> <TD>M1</TD> <TD>100</TD> <TD>T2 100% in 8 Hours</TD> <TD>3.2022</TD> <TD>4.2022</TD> </TR> <TR> <TD>M1</TD> <TD>90</TD> <TD>T2 90% in 8 Hours</TD> <TD>5.2022</TD> <TD>null</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Can you please suggest/help on how can i transform data input into output as shown above..</P> Wed, 18 May 2022 10:59:12 GMT https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932371#M76819 vish123 2022-05-18T10:59:12Z Re: Need help on Qlik Sense Transformation from below given input https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932423#M76822 <P>&nbsp;</P> <P>The OUPTPUT table has&nbsp;</P> <P>3 dimensions</P> <P>and 2 expressions</P> <P>Date(Min(Date#(Date, 'M.YYYY')), 'M.YYYY')</P> <P>IF(COUNT(Date)=1, NULL(), Date(Max(Date#(Date, 'M.YYYY')), 'M.YYYY') )</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="maxgro_0-1652876216137.png" style="width: 747px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/79732iE26628A627C552F8/image-dimensions/747x412?v=v2" width="747" height="412" role="button" title="maxgro_0-1652876216137.png" alt="maxgro_0-1652876216137.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 18 May 2022 12:19:00 GMT https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932423#M76822 maxgro 2022-05-18T12:19:00Z Re: Need help on Qlik Sense Transformation from below given input https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932491#M76825 <P>Hi Maxgro,</P> <P>Wonderful, thanks a lot for your help:)</P> Wed, 18 May 2022 13:28:12 GMT https://community.qlik.com/t5/App-Development/Need-help-on-Qlik-Sense-Transformation-from-below-given-input/m-p/1932491#M76825 vish123 2022-05-18T13:28:12Z