Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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)