I have a table with diff fields and i want to select some fields

[ferha_jafri]

Hi Everyone,

I have a table with 100 fields values i want to include 7 field values in a straight table.eg i have str_desc table and i want to include total revenue,revenue from operation etc fields included in a straight table with diff expression based on these fields.PLZ reply

Thanks in advance

Ferha Jafri

[narender123]

Simply add those column as a dimention and add different expression in property of expreesion tab of straight table.

Thanks

[ferha_jafri]

Sorry i have mentioned wrong question ,my question is have a field and i want to include some field values not all field values of a field and on those field values i have to make some calculations.

[narender123]

Can you tell me whats type of these field value, whats the value and what value you want in your straight table?

[ferha_jafri]

The table contains diff Profit/loss parameters as Total revenue,Revenue from operations,ROCE,etc so what i have to do is i have to suppose include Total revenue for which i have a formula to calculate which i can apply in expression but i am not able to include selected field values of a field in dimensions

[narender123]

Sorry i didnt understand.Can you give me idea with some example .eg wriiten as text in text body as i dont have developer lecense.

[ferha_jafri]

Yeh sure i am sending you my qlikview page in that you will find a field STR_DD_DIM with lot of field values in that i want to show total revenue,revenue from operations,EBITDA etc field values with some calculation in the expression with again same fields values in the same field.

[narender123]

Hi Ferha

Sry for late reply.

As i understand, i have attached the qvw file.

Pls see the attachment file.

Thanks.

Narender