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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding Filter

Hi,

I have a problem, i have this table:

Sales Own F/V

123 12 14

456 11 15

789 12 14

The columns in the table are filters, I need to sum sales ignoring the colum F/V, how can i do this??

Greetings

Carlos

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

assuming i understood you

you can use set analsys

somthing in the lines of:

sum( {<F/V = >} Sales )

this way you calcuate the expression with out any selection in the field

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

assuming i understood you

you can use set analsys

somthing in the lines of:

sum( {<F/V = >} Sales )

this way you calcuate the expression with out any selection in the field

Not applicable
Author

Thank you very much for your answer.

Greetings

Carlos