urgent help - Looping table in expresion

[#1]

Hi All,

Need help.

I have a table as below:

Tab1:

ID, DateX

1,25/01/2012,

2,01/11/2013,

3,21/10/2012,

4,22,03/2014

5,31/01/2014

And I have a variable(vMthMax) which stores date.

__________________________________________________________________

What I need is: total count of the records matching and unmatching in that table where =

if DateX IS NOT NULL AND DateX <= vMthMax.

Thanks,

Lakshmi.

[danieloberbilli]

maybe something like this:

[#3]

Hi Danial,

Thanks for the reply, Can I ask one thing?

Irrealavent of selection of month or year or day...

how do I get total count of the records where <= (vMthMax) from my table? Is it possible?

i.e. eventhough user selects, month, year, my vMthMax will not change, and i want records where <= (vMthMax).

Thanks.

[#4]

Can any one help me on this?

Irrealavent of user selection on dashboard  (e.g. month or year or day)...

how do I get total count of the records where <= (vMthMax) from my table? Is it possible?

i.e. eventhough user selects, month, year, my vMthMax will not change, and i want records where <= (vMthMax).

[danieloberbilli]

You could use this in your expression (see matching 2)

count({<DateX={"<=$(vMthMax)"}, Month=,Year=>} total ID)

Please find example attached