Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
delbooth
Contributor II
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
Partner - Creator II
Partner - Creator II

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


thks

View solution in original post

5 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi,

use Column(number of the column)..

example:

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

Screenshot_1.jpg

kaanerisen
Creator III
Creator III

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
Partner - Creator II
Partner - Creator II

Hi,

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

delbooth
Contributor II
Contributor II
Author

Thanks

PabloTrevisan
Partner - Creator II
Partner - Creator II

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


thks