Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Have a dimension of difference of 2 dates

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?

1 Solution

Accepted Solutions
matt_crowther
Valued Contributor

Re: Have a dimension of difference of 2 dates

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

1 Reply
matt_crowther
Valued Contributor

Re: Have a dimension of difference of 2 dates

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

Community Browser