topic Re: Min(Date) in Calculated Dimension? in QlikView

Min(Date) in Calculated Dimension?

dmohanty — Sat, 21 Feb 2015 02:29:06 GMT

Hi All,

As per the above image I want to do 2nd Column - 3rd Column to show as a Calculated Dimension.

The logic is the 2nd column should pick the Minimum of the Date value.

How can this be done in a Chart?

PrashantSangle — Sat, 21 Feb 2015 04:13:02 GMT

Hi,

In Dimension it is not possible.

Try it in Expression.

and showing difference between two date use Interval()

Regards

MK_QSL — Sat, 21 Feb 2015 11:06:27 GMT

=Interval(Aggr(Min([EDI Promise Date])-[Doc Create Date],[Supplier ID]),'DD')

timanshu — Sat, 21 Feb 2015 11:45:18 GMT

Hi,

you can do like this in expression to work:

=Interval(vMinDate-[Doc Create Date],'DD')

where vMinDate is variable defined as : =Min([EDI Promise Date])

Expression gives No of Days that two dates differ.