topic Re: Help with straight table. in QlikView https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392119#M814509 <HTML><HEAD></HEAD><BODY><P>Looks like you need measure with Relative option checked?</P></BODY></HTML> Mon, 11 Sep 2017 15:34:11 GMT Anil_Babu_Samineni 2017-09-11T15:34:11Z Help with straight table. https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392118#M814508 <HTML><HEAD></HEAD><BODY><P>Hi, could someone help me? i have the table 1 and i want to build the table 2. Could someone tell me how to do that in a straight table?</P><P>MargenAct, MargenPas, Trading, Comtotal and RentTotal are numeric values.</P><P><IMG alt="Captura.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176135_Captura.PNG" style="height: auto;" /></P><P>(Table 1)</P><P><IMG alt="Captura.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/176136_Captura.PNG" style="height: auto;" /></P><P>(Table 2)</P><P></P><P>Many thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392118#M814508 Anonymous 2020-11-25T16:16:04Z Re: Help with straight table. https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392119#M814509 <HTML><HEAD></HEAD><BODY><P>Looks like you need measure with Relative option checked?</P></BODY></HTML> Mon, 11 Sep 2017 15:34:11 GMT https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392119#M814509 Anil_Babu_Samineni 2017-09-11T15:34:11Z Re: Help with straight table. https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392120#M814510 <HTML><HEAD></HEAD><BODY><P>I dont know what is that, if i solve only one dimension with the calculated expression associated, then i will do the same for the others.</P><P></P><P>For example the dimension: Margen Activos - must sum the field MargenAct with some filters of date. i Only want to sum the last date, but if i resolve how to build the dimension and the expression, then i can filter the expression in the set analysis.</P><P></P><P>Sorry for my english and many thanks</P></BODY></HTML> Mon, 11 Sep 2017 15:38:17 GMT https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392120#M814510 Anonymous 2017-09-11T15:38:17Z Re: Help with straight table. https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392121#M814511 <HTML><HEAD></HEAD><BODY><P>The relative option checked is to show the %, but i dont know how to build the dimension and calculate the expression with the data i have.</P></BODY></HTML> Mon, 11 Sep 2017 15:39:11 GMT https://community.qlik.com/t5/QlikView/Help-with-straight-table/m-p/1392121#M814511 Anonymous 2017-09-11T15:39:11Z