topic Re: Help with max and min date! in QlikView

Help with max and min date!

sal07 — Thu, 22 Jun 2017 10:14:02 GMT

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

Kushal_Chawda — Thu, 22 Jun 2017 16:31:52 GMT

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

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

sal07 — Sat, 24 Jun 2017 18:16:43 GMT

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

Anil_Babu_Samineni — Mon, 26 Jun 2017 01:14:46 GMT

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

ankur_abhishek — Mon, 26 Jun 2017 04:33:00 GMT

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

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