Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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