topic calculated dimension in expression in QlikView

calculated dimension in expression

Wed, 12 Jan 2011 16:25:20 GMT

Hi,

I have a issue where I have a calculated dimension where I need to use the value in an expression. Is there a way to use this value in my expression? Please note that my chart does not work when I use the calculated dimension as an expression.

Thanks for any help you can provide!

calculated dimension in expression

Wed, 12 Jan 2011 16:32:11 GMT

Hi, can you write what you need, simple example? I have some problems with it, maybe i can help you...

calculated dimension in expression

Wed, 12 Jan 2011 17:01:15 GMT

i made the following dimension:

=if(startdate > From, From, startdate))

I want the following expression:

=enddate-startdate

startdate should be the above dimension.

calculated dimension in expression

Fri, 14 Jan 2011 12:28:31 GMT

Hi!

Try that expression :


=enddate - if(startdate > From, From, startdate)

i try :


=day(if(startdate > From, From, startdate)) - x

my data:


LOAD * INLINE [
 name, startdate, From, x
 john, "2010-10-10", "2010-10-06", 3
 mad, "2010-10-10", "2010-10-12", 4
 tad, "2010-10-10", "2010-10-02", 5
];

it work in simple bar chart with dimension =if(startdate > From, From, startdate)

calculated dimension in expression

Fri, 14 Jan 2011 15:56:27 GMT

Thank you for the answer solved my problem

calculated dimension in expression

Fri, 14 Jan 2011 16:38:02 GMT

glad to help, im beginner in QV, like you, it's hard to understand this strange product without any book,

unfortunately, help and manual don't answer on all question.