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: 
linoyel
Specialist
Specialist

Filter rows in a table based on expression result

Hi!

I have to show agents and their sales where sum of sales is a set analysis expression: Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income)

- but only if sum of sales is less then 6000.

How do I do it?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=If( Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income)<6000,

           Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income),

     0)


Then in the presentation tab check 'Suppress Zero Values'.

View solution in original post

5 Replies
tresesco
MVP
MVP

Try like:

=If( Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income)<6000,

           Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income),

     0)


Then in the presentation tab check 'Suppress Zero Values'.

avinashelite

Hi Linoy,

Can you please elaborate your problem.

linoyel
Specialist
Specialist
Author

Great!!! Thank you

linoyel
Specialist
Specialist
Author

I have it a bit more complicated now...

I need to show agent sales in the same table for current and previous months, only when in current month sum of income < 6000.

The problem is that when in current month some agent sold for 7500 then I get 0 which is not getting suppressed cause I have other values of previous month which are not 0...

So how I can hide these lines which get "0"  in the sales of current month?

linoyel
Specialist
Specialist
Author

Well, I managed to do it, but I loose values which are 0 cause there were no sales. They are suppressed together with not matching values...