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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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