topic basic filter for chart in QlikView

basic filter for chart

Wed, 27 Jan 2010 19:00:40 GMT

From my fact data I have a special chart which should by default use only a subset of data (based on NOT NULL for one of the attributes)

The filter should be only for this chart and not in general.

How to best accomplish this?

Juerg

basic filter for chart

Wed, 27 Jan 2010 20:01:44 GMT

Use Set Analysis on the expressions of the chart. Something like:

Sum({<FIELD -= {}>} VALUE)

That would give you the Sum of VALUEs where FIELD is not Null. We'd need more specifics on your data to give a more specific example.

basic filter for chart

Thu, 28 Jan 2010 16:13:04 GMT

I have records with planned and actual values. For some records only planned values exist.

Some table charts show all records, actual show up as null.

I wanted now to create a table that concentrates on planned-actual differences and should use only records that have an actual value set. I could create an additional selection for "actual only" but this will then impact my other tables too and might confuse the user thinking everything has actual values.

So what I was looking for is a subset of all records with existing actual values for this table chart only.

I could create a separate data table when loading that contains only records containing actual values but this will (almost) double the used memory?

basic filter for chart

Thu, 28 Jan 2010 18:55:46 GMT

No need for another dataset. Set Analysis is exactly what you want, but you need the Set Expression in each expression on the table.

Sum({<Actual -= {}>} VALUE)

If each expression contains the Actual -= {} Set Expression, then records where Actual is Null will be ignored and your chart will only display data for records where Actual has a value.