Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

delbooth
New Contributor II

Table visualisation

Hi.

I have 5 column table visualisation, with the columns :

1 Vehicle Registration - generated from reading a field in atable

2 Availability - generated via calculation using data from fields in tables

3 Performance -generated via calculation using data from fields in tables

4 Quality -generated via calculation using data from fields in tables

5 OEE -generated via calculation using data from fields in tables

My questions are

1. Is it possible to multiply column 2,3 and 4 to get a value in column 5 without combining the calculations used in columns 2,3 and 4 as it becomes very large ie by saying in column 5 measure multiple column,2,3 and 4

Thanks

1 Solution

Accepted Solutions
PabloTrevisan
Contributor II

Re: Table visualisation

Please Del, if the answer helped you, please check the correct answer.


thks

5 Replies
PabloTrevisan
Contributor II

Re: Table visualisation

Hi,

use Column(number of the column)..

example:

Column(1) + Column(2) - Column(3)

Screenshot_1.jpg

kaanerisen
Contributor III

Re: Table visualisation

Hi Del,

Just use column names in expression.

For ex:

([Performance]*[Quality])-[Availability]

It may show error on expression editor but it will work as you want.

mithilesh17
Contributor

Re: Table visualisation

Hi,

In your case, write this in Column 5 ->  Column(2) * Column(3) * Column(4)

delbooth
New Contributor II

Re: Table visualisation

Thanks

PabloTrevisan
Contributor II

Re: Table visualisation

Please Del, if the answer helped you, please check the correct answer.


thks

Community Browser