topic Set Analysis not working in QlikView

Set Analysis not working

Tue, 08 Nov 2011 17:41:43 GMT

Count of Implemented date with a condition of Planned date lesser than today

=Count({<PLANNEDDATE={<$(vToday)>}IMPLEMENTEDDATE)

But it doesnt seem to work. any help would be appreciated

danielrozental — Tue, 08 Nov 2011 17:57:28 GMT

Try something like this

=Count({<PLANNEDDATE={"<'$(vToday)'"}>}IMPLEMENTEDDATE)

Tue, 08 Nov 2011 18:03:33 GMT

its not working. I know is something to deal with quotes, but not able to figure it out.

swarup_malli — Tue, 08 Nov 2011 18:10:09 GMT

Satheesh,

If (PLANNEDDATE= vToday,count(IMPLEMENTEDDATE)

Regards

Swarup

Tue, 08 Nov 2011 18:14:44 GMT

Swarup,

I cant use if since I have many conditions, need it in set analysis

swarup_malli — Tue, 08 Nov 2011 18:17:50 GMT

try this =Count({$<PLANNEDDATE={$(vToday)}>}IMPLEMENTEDDATE)

Tue, 08 Nov 2011 18:23:27 GMT

My condition is Planned Date is lesser than today and not equal to.

If I lesser than, some issue with the syntax. Meaning am missing the quotes some where

swarup_malli — Tue, 08 Nov 2011 18:26:45 GMT

Sateesh ,

Can u create a sample appliction and upload it,

And also elaborate on your requirment.

Regards

Swarup

swarup_malli — Tue, 08 Nov 2011 18:41:34 GMT

did u try this ..what is the error u are getting

Count({<PLANNEDDATE < {<$(vToday)>}IMPLEMENTEDDATE)