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

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

hrolofs — Tue, 19 Apr 2011 09:07:14 GMT

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 — Tue, 19 Apr 2011 09:11:52 GMT

hi henry

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

HTH

hrolofs — Tue, 19 Apr 2011 09:55:32 GMT

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 — Tue, 19 Apr 2011 10:08:59 GMT

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 — Tue, 19 Apr 2011 11:04:15 GMT

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