topic Set Analysis and Count function in QlikView

Set Analysis and Count function

Fri, 25 Sep 2009 15:13:13 GMT

Hi,

I am trying to use set analysis in a count function.

This works:

Count({<montha={"6","7","8"}>} idx*NewMail_Flag)

But this returns 0:

Count({<montha={"<=8"}>} idx*NewMail_Flag)

and this returns 0:

Count({<montha={">6<8"}>} idx*NewMail_Flag)

I want to supply a range in my count function. For Example: > =6 And <= 8.

I would be grateful if anyone can help.

Thanks

Ardy

Fri, 25 Sep 2009 19:40:59 GMT

Hi Ardy,

see the attached example.

Good luck!

Rainer

Fri, 25 Sep 2009 20:43:44 GMT

Thanks Rainer. The example you supplied helped. The problem is fixed now. In the load script I needed to format the month correctly.

.Ardy