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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

EXPRESSION PROBLEM

hi,

I HAVE TWO TABLES:

Resource IDResource Name
1

A

2B
3C

DATEResource IDAVAILEBLE HOURSWORK HOURS
1.1.141910
1.1.14298
1.1.143912
2.1.14199
2.1.14298

I WANT TO SHOW A NUMBER -

HOW MANY RESURCE HAVE MORE WORK HOURS THAN AVAILEBLE HOURS

IN MY CASE - 2 :

1 - AVAILEBLE HOURS:18 ,WORK HOURS:19

3 - AVAILEBLE HOURS:9 ,WORK HOURS:12

WHAT EXPRESSION SHOULD I WRITE?

TNX.

10 Replies