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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Don't count any row with an specific item on a field

Hi!!

I have a table with three fields: ID, TIME1, TIME2 , USE1, USE2. And a table with the dimension ID, and the expression Sum(TIME1) + Sum(TIME2). But I only want the expression to sum TIME1 if its related USE1 is not 'INTERN_USE' and to sum TIME2 if its related USE2 is not 'INTERN_USE'. How can I write this expression?

Thanks!!

Júlia

4 Replies
MK_QSL
MVP
MVP

SUM({<USE1 -= {'INTERN_USE'}>}TIME1) + SUM({<USE2 -= {'INTERN_USE'}>}TIME2)

Not applicable
Author

if already tried this but it doesn't work:(

MK_QSL
MVP
MVP

Provide sample file or sample application.

Not applicable
Author

ok you have it, its a little bit different than the question because I hoped it would exist an easy way.. You will see that I have three charts, related in different ways. I'll like that in the table the second, third and fourth column (Sum of fields) sum without the item 'Uso_Interno' in the field Etiquetas