topic Re: Function within a set analysis expression in QlikView

Function within a set analysis expression

Fri, 07 Sep 2012 08:12:39 GMT

Hi,

I want to be able to print total number of IDs my table for the latest month.

To retrieve the latest month I use MaxString([CreationDate]) which gives me the correct month in format '2012-03'.

When I try to use it in my set analysis expression it does not work, it comes out null:

(This is put in a texbox)

=count( {$<CreationDate = {$(=MaxString(CreationDate))} >} [E_ID]);

I can use the following expression and it works:

=count( {$<CreationDate = {'2012-03'} >} [E_ID]);

I'm pretty sure I just dont know the syntax...

Regards

Mikael

rajni_batra — Fri, 07 Sep 2012 08:57:42 GMT

=count( {$<CreationDate = {"$(=MaxString(CreationDate))"} >} [E_ID]);

or u can store maxstring(date) in a variable and use that variable, that can also help u

Fri, 07 Sep 2012 09:11:46 GMT

Thank you!