Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Help with max and min date!

Hi everyone,

Iam new here in this community, i want help to separate two values deepens on max and min date.

the expression for max date: (if the date is max then count id)

=count(distinct(if(max(date), id)   

the expression for min date: (if the date is min then count id)

=count(distinct(if(min(date), id)   

Thnx for help

4 Replies
Highlighted

Re: Help with max and min date!

=count({<Date={"$(=Date(max(Date)))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date)))"}>}ID)  -> from Min

Highlighted
New Contributor

Re: Help with max and min date!

Thank you Kushal , but the code dosn't work !

Highlighted

Re: Help with max and min date!

May be the reason date format? What is the date format from your Model

=count({<Date={"$(=Date(max(Date),'YourFormatHere'))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date),'YourFormatHere'))"}>}ID)  -> from Min

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor III

Re: Help with max and min date!

=count({<Date={"$(=Date(max(Date),'DD/MM/YYYY'))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date),'DD/MM/YYYY'))"}>}ID)  -> from Min