topic urgent help - Looping table in expresion in QlikView

urgent help - Looping table in expresion

Wed, 17 Sep 2014 12:24:58 GMT

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 — Wed, 17 Sep 2014 13:06:43 GMT

maybe something like this:

Wed, 17 Sep 2014 13:57:38 GMT

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.

Wed, 17 Sep 2014 14:14:33 GMT

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 — Thu, 18 Sep 2014 00:25:57 GMT

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

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

Please find example attached