calculated dimension in expression

[#1]

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!

[#2]

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

[#3]

i made the following dimension:

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

I want the following expression:

=enddate-startdate

startdate should be the above dimension.

[#4 · Accepted solution]

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)

[#5]

Thank you for the answer solved my problem

[#6]

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.