topic Filter rows in a table based on expression result in QlikView

Filter rows in a table based on expression result

linoyel — Tue, 29 Jul 2014 07:23:40 GMT

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?

Re: Filter rows in a table based on expression result

tresB — Tue, 29 Jul 2014 07:33:03 GMT

Try like:

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

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

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

Re: Filter rows in a table based on expression result

avinashelite — Tue, 29 Jul 2014 07:33:19 GMT

Hi Linoy,

Can you please elaborate your problem.

Re: Filter rows in a table based on expression result

linoyel — Tue, 29 Jul 2014 07:48:17 GMT

Great!!! Thank you

Re: Filter rows in a table based on expression result

linoyel — Tue, 29 Jul 2014 12:45:39 GMT

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?

Re: Filter rows in a table based on expression result

linoyel — Tue, 29 Jul 2014 13:28:16 GMT

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...