4 Replies Latest reply: Jun 22, 2017 3:03 AM by Tom Puschmann

# Calculate by selected Data from Straight Table

Hello Everyone,

I've a question by QlikView and need help.

In my analysis I have insert a Straight Table.

Example:

(Variable aus DB) Feld_Bezeichnung
(Variable asu DB) Feld_Inhalt
NameMax Mustermann
Age25
postal code99999

- "Feld_Bezeichnung" is a variable of Database, just as "Feld_Inhalt".

- Field Content of "Age" is changing by every Person.

My Question:

I would like to multiplicate the field content of "Feld_Bezeichnung" = "Alter" by 4   (= 25 x 4).

Do you have any idea?

• ###### Re: Calculate by selected Data from Straight Table

Would you be able to share a sample to see how you have setup your chart?Preparing examples for Upload - Reduction and Data Scrambling

• ###### Re: Calculate by selected Data from Straight Table

have you tried in the expression =column(1)*4

where column(n) is your nth expression in the table

• ###### Re: Calculate by selected Data from Straight Table

Hello Everyone,

I can't post a sample because there are confidential Data.

We can solve the Question with an if, then Expression.

Thank you very much.