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: 
Not applicable

How to get the value of cell in 2-dimensional table

I have a table with two dimensions, as i get the value of a specific cell?

eg.

Dimension 1

Dimension 2

      Expression 1

      Expression 2

      Expression 3

      Expression 4

If the dimensions 1 and 2 are horizontal, eg.

                           ---------------  Dimension 1-1------------------ --------------- Dimension 1-2 ------------------

Dimension 2-ADimension 2-BDimension 2 ADimension 2-B
Expression 1
Expression 2
Expression 3
Expression 4

As i can do in <Dimension 1-1, Dimension 2-B>

     Expression 3 =  [Expression 1 <Dimension 1-1, Dimension 2-A>] / [Expression 3 <Dimension 1-1, Dimension 2-A>]

thanks.

1 Reply
Not applicable
Author

For anyone having the same problem.

I tried to use macros, i did not know how.

Finally the expression of some cells, i stored in variables and so, instead of referring to cells, only use the variables.

eg.

var_expression1_A =sum(<expression>)

var_expression1_B =avg(<expression>)

expression 3 = if(dimension1=1 and dimension2='B', $(var_expression1_A)/$(var_expression1_B))