Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Partner
Partner

Min(Date) in Calculated Dimension?

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?

3 Replies
Highlighted

Re: Min(Date) in Calculated Dimension?

Hi,

In Dimension it is not possible.

Try it in Expression.

and showing difference between two date use Interval()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
MVP
MVP

Re: Min(Date) in Calculated Dimension?

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

Highlighted
Contributor III

Re: Min(Date) in Calculated Dimension?

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.