topic Re: last date in QlikView

last date

Anonymous — Thu, 29 May 2014 05:11:02 GMT

hi,

how do i calculte count for some field for the max day?

emp:

count(distinct(myfield)) , i want to show only for the max date that i have ( the same if i chose the date manule).

thanks'

yarin.

tresB — Thu, 29 May 2014 05:14:42 GMT

Define a variable like:

vMax =Date(Max(DateField)) // Put '=' in the definition of the variable

Then expression should be like: =Sum({<DateField={'$(vMax)'}>} Distinct YourField)

anbu1984 — Thu, 29 May 2014 05:17:32 GMT

count({<datefield={$(=Max(datefield))}>} distinct myfield)

jagan — Thu, 29 May 2014 05:22:59 GMT

Hi,

Try like this

Create a variable like this

vMaxDate = Date(Max(DateDimensionName))

Note: your DateDimension values and Today() should be in same format

Now use below expression

=Sum({<DateDimensionName={'$(vMaxDate)'}>} Distinct DimensionName)

If you don't want to use variables then try like this

=Sum({<DateDimensionName={'$(=Date(Max(DateDimensionName)))'}>} Distinct DimensionName)

Hope this helps you.

Regards,

Jagan.