Have a dimension of difference of 2 dates

[#1]

Hi community,

I want to have a dimension that is the difference of 2 dates.  The dates are Date and the min(Date) of the current selections.  This doesn't work though: Date-min({$}Date)...  Any ideas?

[matt_crowther · Accepted solution]

Try the following as a Calculated Dimension:

=Date-min(Total Date)

Works for me.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI