Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis not working

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

8 Replies
danielrozental
Master II
Master II

Try something like this

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

Not applicable
Author

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

swarup_malli
Specialist
Specialist

Satheesh,

If (PLANNEDDATE= vToday,count(IMPLEMENTEDDATE)

Regards

Swarup

Not applicable
Author

Swarup,

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

swarup_malli
Specialist
Specialist

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

Not applicable
Author

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
Specialist
Specialist

Sateesh ,

Can u create a sample appliction and upload it,

And also elaborate on your requirment.

Regards

Swarup

swarup_malli
Specialist
Specialist

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

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