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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression

Hi all,

truck trucks.png

I got this table showing me the Km's per truck per week. Now I would like it to show me only the trucks that haven't had any kilometers per week. If I now would say pick week 1 it will show me the trucks that have had kilometers that week. And when I select 10 weeks it will also show me the trucks in week 1 that had 0 kilometers.

expression:
sum(Distance)

kind regards,

Vincent

11 Replies
Not applicable
Author

😃

alexandros17
Partner - Champion III
Partner - Champion III

Use advanced editor when you reply and attach a file