QV10: Table Diagram, function for dimensions value like column()

[hrolofs]

Hello,

if there a possibilty to have accecc to the dimension value in the expression of a table diagram like the column function?

Regads, Henry

[sushil353]

hi henry

can u little bit more clear to your problem with example..

HTH

[hrolofs]

Table - Diagram

Inside the diagram i use this definition:

Dimension (Ticket/Message)

=Aggr(if (IsNull(T.OVO_ID) or T.OVO_ID = '','no Message',Count(DISTINCT [T.Incident Number])), T.OVO_ID)

Column1 (Frequency)

Count(DISTINCT T.OVO_ID)

Column2 (Ticket)

Count(DISTINCT [T.Incident Number])

Column3 (Difference)

Column(2) - Column(1)

I want to do something like this

Column3

If (Dimension(1) = 'no Messages', ...., ...)

With the function Column(x) I have access to the column value, but how is the dimension value available?

Regards, Henry

[jonathandienst]

Henry

If I understand you correctly, you want some shorthand like Column(n) to access an expression column, but to access a dimension instead?

The short answer is that this would be useful, I don't think that is possible, but you can use the dimension expression in you if expression:

If(<dimension expression here> ='no Messages', ...)

Hope that helps
Jonathan

[hrolofs]

Hi Jonathan,

yes, you understand me correct.

I have done it now like you described, but i was "amazed" that there is no way to access direct the dimension value like the column values.

Thanks, Henry