topic Display Data in App Development https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434765#M96922 <P>Hello,</P> <P>How can I&nbsp;get the Tab2 as a result please and knowing that the reduction is not a measure.</P> <P>Tab1:</P> <TABLE> <TBODY> <TR> <TD width="205"> <P>Date</P> </TD> <TD width="205"> <P>Product</P> </TD> <TD width="205"> <P>Discount</P> </TD> </TR> <TR> <TD width="205"> <P>26/03/2024</P> </TD> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>10%</P> </TD> </TR> <TR> <TD width="205"> <P>02/04/2024</P> </TD> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>15%</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Tab2:</P> <TABLE> <TBODY> <TR> <TD width="205"> <P>Product</P> </TD> <TD width="205"> <P>Week 13</P> </TD> <TD width="205"> <P>Week 14</P> </TD> </TR> <TR> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>10%</P> </TD> <TD width="205"> <P>15%</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 26 Mar 2024 14:14:13 GMT Amina 2024-03-26T14:14:13Z Display Data https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434765#M96922 <P>Hello,</P> <P>How can I&nbsp;get the Tab2 as a result please and knowing that the reduction is not a measure.</P> <P>Tab1:</P> <TABLE> <TBODY> <TR> <TD width="205"> <P>Date</P> </TD> <TD width="205"> <P>Product</P> </TD> <TD width="205"> <P>Discount</P> </TD> </TR> <TR> <TD width="205"> <P>26/03/2024</P> </TD> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>10%</P> </TD> </TR> <TR> <TD width="205"> <P>02/04/2024</P> </TD> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>15%</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Tab2:</P> <TABLE> <TBODY> <TR> <TD width="205"> <P>Product</P> </TD> <TD width="205"> <P>Week 13</P> </TD> <TD width="205"> <P>Week 14</P> </TD> </TR> <TR> <TD width="205"> <P>Item</P> </TD> <TD width="205"> <P>10%</P> </TD> <TD width="205"> <P>15%</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 26 Mar 2024 14:14:13 GMT https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434765#M96922 Amina 2024-03-26T14:14:13Z Re: Display Data https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434791#M96924 <P>If you are not dependent on making filters on discount value then consider making a pivot table consisting of the dimensions Product&nbsp; and Week in combination with the&nbsp; measure <EM>=Only(Discount)</EM></P> <P>&nbsp;</P> <P>If thats not applicable for you, then you might have a look at the <A href="https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470" target="_self">generic load</A> blog poat by HIC.</P> Tue, 26 Mar 2024 14:51:42 GMT https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434791#M96924 Vegar 2024-03-26T14:51:42Z Re: Display Data https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434796#M96925 <P>Thank you for your reply</P> Tue, 26 Mar 2024 14:59:08 GMT https://community.qlik.com/t5/App-Development/Display-Data/m-p/2434796#M96925 Amina 2024-03-26T14:59:08Z