Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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)
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.