to make an expression with a field out of a table

[chriscools]

Hey,

i want to show a percentage by making a division with two numbers.

one is the count of items in a table, this is no problem.

but the second number should be a part of a table, how do i do this?

the table has four coloms, in the fourth colom there is quantity, but i want to divise with the quantity corresponding

in the table with value "main" in the first column and "bulk" in the second column.

How should i set up the expression to get the secund number?

thanx for your help!

grtz,

chris

[disqr_rm]

If table you mean by table on the QlikView screen (as chart table), in the expression you can simply use column() function. column(1) will get you result of expression #1 in your chart. So you can make an expression like column(4) / column(1) or column(4) /column(2).

Is this what you are looking for?

Or if you table by table in the data model, you can create a calculated filed in the script itself.

[chriscools]

Hello,

thank you for the response!

i was trying to put a print screen into this reply to exactly show what i mean, but i can't copy in the print screen...

I have the table in 2 ways, on the qlikview screen and also as a table in the data model.

What i want to do is to divise a number by one value of a column, not by the value of the whole column.

it must be a specific row that can be defined by the values of the other columns in the same row.

what i'm searching for is this:

number 1 / the value in column (3) that is in the same row als value X in column(1) and value y in column (2)

if possible i would like to learn the two ways... in a table and in the script.

thank you very much for your answer!!!!

grtz,

chris