topic Filtering data out of a straight table chart in QlikView

Filtering data out of a straight table chart

Wed, 02 Sep 2009 16:45:41 GMT

Hi all,

I have a very simple chart with 2 dimensions and 1 expression.

One of the dimenions is a field called 'TRUE_CLIENT'

I want to be able to filter out any records that have a TRUE_CLIENT of 'NONE'

How can I do this within the table?

Thanks in advance,
Matt

Filtering data out of a straight table chart

Wed, 02 Sep 2009 17:52:46 GMT

you want to filter the expression to show records of TRUE_CLIENT of 'NONE'

= Sum( {$<TRUE_CLIENT={NONE}>} Value)

If you want to filter the dimension then you can use

=if(TRUE_CLIENT = 'NONE',TRUE_CLIENT_ID)
The problem is that it will return a blank row for all other clients, you can then select 'SUPRESS WHEN VALUE IS NULL' and this solves this problem

Another option is to place a marker when loading the data from the script

Table:
LOAD *,
if(TRUE_CLIENT = 'NONE', 'N_TRUE_CLIENT') as N_TRUE_CLIENT;
SQL SELECT *
FROM TABLE_ORDERS;

Now you have a new dimension called N_TRUE_CLIENT which you can use in your graph or report.

Filtering data out of a straight table chart

eric_dielessen — Wed, 02 Sep 2009 17:54:04 GMT

I think you need to do the following on the dimension tab:

Replace the dimension TRUE_CLIENT by a calculated dimension with following formula in it: =If(TRUE_CLIENT = 'NONE', Null(), TRUE_CLIENT).
Mark the checkbox 'Suppress when value is null'.