Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rodrig1302
New Contributor III

Help with straight table.

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.

Captura.PNG

(Table 1)

Captura.PNG

(Table 2)

Many thanks

3 Replies

Re: Help with straight table.

Looks like you need measure with Relative option checked?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
rodrig1302
New Contributor III

Re: Help with straight table.

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

rodrig1302
New Contributor III

Re: Help with straight table.

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.