topic Expression issue with max and date in QlikView

Expression issue with max and date

jagjivvt — Wed, 20 Jan 2016 14:35:37 GMT

Hi,

if i use =max(Date)-7 in the label it works, but when i use the same in set analysis no values are being shown.

count($<{Date={"$(=max(Date)-7)"}>} Distinct Names)

result should be the number of names for max Date.

help please

thanks

marcus_sommer — Wed, 20 Jan 2016 16:49:46 GMT

You need probably a date-formating like:

count($<{Date={"$(=date(max(Date)-7, 'YourDateFormat')"}>} Distinct Names)

- Marcus

sunny_talwar — Wed, 20 Jan 2016 16:50:00 GMT

Try this:

Count($<{Date={"$(=Date(Max(Date)-7, 'YourDateFieldFormatHere'))"}>} Distinct Names)

swuehl — Wed, 20 Jan 2016 16:50:28 GMT

Try to format according your Date field format:

count($<{Date={"$(=Date(max(Date)-7))"}>} Distinct Names)

Wed, 20 Jan 2016 16:54:08 GMT

Vijay, Max function return the number value for date and you need to convert into your date format.

count($<{Date={"$(=date(max(Date)-7, 'YourDateFormat')"}>} [Distinct Names])

sunny_talwar — Wed, 20 Jan 2016 16:57:26 GMT

Your Set Analysis brackets are also not in correct places. Try this:

Count({$<Date={"$(=Date(Max(Date)-7, 'YourDateFieldFormatHere'))"}>} Distinct Names)