# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
Contributor III

## Evaluate variable for each dimension value

I have a table with dimension 'Point' (which has four values: One, Two, Three, Four) and expression:

The variables are:

vAPS_Current = SUM(Current_points)/SUM(Qual_size)

All works as I would expect, but it doesn't give the expression value for each dimension value.

So, with all selections cleared I get the following table:

OneTwoThreeFour
EXP:47.9 (A-)()()()

Then, if I select 'Point' Two, I get the following table:

OneTwoThreeFour
EXP:()55 (A+)()()

I don't understand why it isn't evaluating for each dimension value?

Does anyone know what I can do to have all cells filled with the correct value?

1 Solution

Accepted Solutions
Highlighted
Partner

Hi Jessica,

Thanks.

Aiolos

19 Replies
Highlighted
MVP

## Re: Evaluate variable for each dimension value

If you use this without the variable (directly in your chart), does it still do the same thing? Or is this only when you use it as a variable?

Highlighted
Contributor III

## Re: Evaluate variable for each dimension value

If I remove all the part in red:

Then it evaluates across all dimension values (just incorrectly).

So I guess it's actually an issue with the expression, rather than the variable...

Highlighted
MVP

## Re: Evaluate variable for each dimension value

Is ONE, TWO, THREE, FOUR (up top) a dimension also? What is it's name? IsAcad or something else?

Highlighted
Contributor III

## Re: Evaluate variable for each dimension value

No, One, Two, Three & Four are the values for the dimension 'Point'

Highlighted

## Re: Evaluate variable for each dimension value

I assume, One , Two, Three .. are the dimension which translate from column to Row. Could be Dual() needed here for measure

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP

Try this

Highlighted
Contributor III

## Re: Evaluate variable for each dimension value

No joy there unfortunately!

That gives me:

OneTwoThreeFour
EXP()()()
Highlighted
Contributor III

## Re: Evaluate variable for each dimension value

Thanks for the suggestion Anil. Unfortunately that's not working.

I just get:

OneTwoThreeFour
EXP()()()
Highlighted
MVP

## Re: Evaluate variable for each dimension value

What do you get for this alone? Anything?