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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Set Analysis when Date is given, then count

Hello, 

I have several DeliveryNumbers tables linked to each other.

One Table is only for inbound and one for outbound. 

I want a KPI Window which count the deliveries which are already send out and if there is no DeliveryDate it means its still there. So I tried several combinations which always give me ZERO:

count({1<[DeliveryDate]-={"0"}>}distinct DeliveryNumber)

count({1<[DeliveryDate]={">0"}>}distinct DeliveryNumber)

Only a simple If-Statement seems to work:

If(DeliveryDate>0, DeliveryNumber) 

But thats only for the table not for the KPI Window. 

I just wanted to know why it doesn't work with Set Analysis. 

Thank you.

Best. 

 

1 Reply
GaryGiles
Specialist
Specialist

Dates are interpreted differently in set analysis than in an if statement.  Try this:

count({1<[DeliveryDate]={">$(=Date(0))"}>}distinct DeliveryNumber)