topic how to create 2 tables from single table data visually in QlikView https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800186#M1211602 <P>Hello,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;could someone help on the following,</P><P>I have a table ,</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>The actual number of rows and columns 100+</P><P>I need to show 2 different views(table chart) in a single sheet,</P><P>Current:</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>Previous:</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>Please take into consideration, I don't want to create 2 separate tables in script due to other required views. is it possible to put a condition that will be applicable for the whole table.</P> Fri, 16 Apr 2021 16:45:57 GMT noviceneil 2021-04-16T16:45:57Z how to create 2 tables from single table data visually https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800186#M1211602 <P>Hello,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;could someone help on the following,</P><P>I have a table ,</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>The actual number of rows and columns 100+</P><P>I need to show 2 different views(table chart) in a single sheet,</P><P>Current:</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>Previous:</P><P>col1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;flag</P><P>12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>Please take into consideration, I don't want to create 2 separate tables in script due to other required views. is it possible to put a condition that will be applicable for the whole table.</P> Fri, 16 Apr 2021 16:45:57 GMT https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800186#M1211602 noviceneil 2021-04-16T16:45:57Z Re: how to create 2 tables from single table data visually https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800312#M1211615 <P>HI&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/24674">@noviceneil</a>&nbsp;</P><P>Might be, if you can use set condition to display the expression for both scenario</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1618742373157.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53182i5527F1144E28DA45/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1618742373157.png" alt="MayilVahanan_0-1618742373157.png" /></span></P><P>&nbsp;</P> Sun, 18 Apr 2021 10:39:41 GMT https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800312#M1211615 MayilVahanan 2021-04-18T10:39:41Z Re: how to create 2 tables from single table data visually https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800330#M1211623 <P>hii..</P><P>&nbsp;</P><P>maybe you can make that flag col as an expression and use set analysis to fulfill this like. .</P><P>dimension : col1 , col2</P><P>expression : only({&lt;flag={1}&gt;}flag)</P><P>you need adjust the flag in expression in other table.</P><P>&nbsp;</P><P>hope this help</P> Mon, 19 Apr 2021 01:58:02 GMT https://community.qlik.com/t5/QlikView/how-to-create-2-tables-from-single-table-data-visually/m-p/1800330#M1211623 andykrst 2021-04-19T01:58:02Z