Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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


thks

View solution in original post

5 Replies
Highlighted
Partner
Partner

Hi,

use Column(number of the column)..

example:

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

Screenshot_1.jpg

Highlighted
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.

Highlighted
Partner
Partner

Hi,

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

Highlighted
Contributor II
Contributor II

Thanks

Highlighted
Partner
Partner

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


thks

View solution in original post