Re: Help with straight table. - Qlik Community

Anonymous · ‎2017-09-11

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?

MargenAct, MargenPas, Trading, Comtotal and RentTotal are numeric values.

(Table 1)

(Table 2)

Many thanks

Anil_Babu_Samineni · ‎2017-09-11

Looks like you need measure with Relative option checked?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-09-11

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.

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.

Sorry for my english and many thanks

Anonymous · ‎2017-09-11

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.