Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to operate with columns in a pivot table

Hi, i'm new in QV, i have found this questions but i haven't found it, i think it must be simply.

I have a pivot table with two colums that each one contains a formula and i need a third column that for example multiplies the other, how can I reference? I have tried to put (column1 + column2) but it shows in the column the text "column1 + column2" not the value of the operation.

Thanks

1 Solution

Accepted Solutions
james
Creator III
Creator III

Easiest way

=column(1) + column(2)

The key is the ()

View solution in original post

5 Replies
Not applicable
Author

Hi,

just use that expression name in the third expression.

For example your

1st expression is sum(Sales) and lable is Sales.

2nd expression is sum(Total Sales) and lable is Total_Sales.

3rd expression would be the name of the 1st and 2nd expression i.e. Sales + Total_Sales.

Check the attachment.

- Sridhar

Not applicable
Author

Ok, i will try it step by step.

Thanks

amit_shetty78
Creator II
Creator II

Hi Raghu, This was interesting. I never figured this out till now.

I would have mentioned my 3rd expression as '=column(1) + column(2)' and a label explicitly mentioned.

Thanks, Amit.

james
Creator III
Creator III

Easiest way

=column(1) + column(2)

The key is the ()

View solution in original post

Not applicable
Author

column(1) + coloumn(2)

paranthesis indicate which column you are trying to refer to.