use column() in set analysis

Anonymous — Thu, 14 Jul 2016 10:17:50 GMT

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!

Re: use column() in set analysis

sunny_talwar — Thu, 14 Jul 2016 12:06:56 GMT

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

Gysbert_Wassenaar — Thu, 14 Jul 2016 12:12:39 GMT

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.