topic Re: Calculate by selected Data from Straight Table in QlikView

Calculate by selected Data from Straight Table

Tue, 30 May 2017 12:20:53 GMT

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
Name	Max Mustermann
Age	25
postal code	99999

- "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?

sunny_talwar — Tue, 06 Jun 2017 13:57:26 GMT

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

tajmohamed30 — Tue, 06 Jun 2017 14:17:56 GMT

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

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

sujeetsingh — Wed, 07 Jun 2017 06:25:55 GMT

Please post a sample.

Thu, 22 Jun 2017 07:03:36 GMT

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.