topic Re: How to use max(date) in set analysis? in QlikView

How to use max(date) in set analysis?

narband2778 — Fri, 10 Oct 2014 21:53:34 GMT

Hi,

I want to count total "orderID" of max(date) in set analysis? Without using a variable? Is this possible?

Many Thanks,

Naresh

albertovarela — Fri, 10 Oct 2014 21:57:34 GMT

Try this: count( {$ < date = {"$(=max(date))"} > } orderID) , you may want to add a Distinct depending on your data...

narband2778 — Fri, 10 Oct 2014 22:09:11 GMT

Hi,

Thanks for the answer, I tried it but it did not work.

However the replacement of the $ sign after the curly brace worked.

=count($ { < date = {"$(=max(date))"} > } orderID)

Thanks,

Naresh

jaimeaguilar — Fri, 10 Oct 2014 22:30:53 GMT

Hi,

sometimes happens that you need to force date format, otherwise Set analysis doesn't recognizes numeric values:

=count($ { <date = {'$(=date(max(date)))'} > } orderID)

also just as a tip, usually single quotes are used for expanding a formula, while double quotes are used for executing searches,

regards

MK_QSL — Sat, 11 Oct 2014 07:51:27 GMT

COUNT({<date = {'$(=Max(date))'}>}Distinct OrderID)

COUNT({<date = {'$(=Max(date))'}>}OrderID)