use column() in set analysis

[Anonymous]

Hello,

I want to use the value of another colomn in the same row in a straight table in an set analysis expression.

Here's the table:

  

This is the expression that I used for the 3the column:

round(Aggr(SUM({<[Titel Gewestplan] = {'$(vRBH)'}>} RBHOppervlakte), [Titel Gewestplan])/ sum(RBHOppervlakte)*100, 0.01)

In stead of the variable "vRBH", I want to use the value of column 1 (for row 1: "agrarische gebieden" and for row 2: "woongebieden...").

I thought I could use "column(1), but that doesn't work.

A variable doesn't work, because I need a different variable for each row.

I'm still quite new to QlikView... Can someone help me with this problem?

Thanks!

[sunny_talwar]

Would you be able to share a sample to look at this?

[Gysbert_Wassenaar]

The problem is that the set is calculated at the chart level, not the row level. You'll have to use an if statement instead.