Edit selection - using filters

[Maciej29]

Hi, I have an issue. Is there any way to add filter for an empty cells ? Or exclude some unwanted value (not numeric) ?

[Anil_Babu_Samineni]

---

@Maciej29 wrote:

Is there any way to add filter for an empty cells :  What is the purpose you are creating?

Exclude some unwanted value (not numeric) : You can use Not Match(FieldName, 'Unwanted1', 'Unwanted2'..)

---

[Maciej29]

I would like to exclude some records because i dont need them in my charts, (but not delete them manually, cannot change master version of my file) and try to avoid built this condition in every chart. That's why i want to filter out only records with value that i want to, or exclude these unwanted.

[dgreenberg]

What if you did a resident load of the data?

OldTable:

Select * from mysource.qvd(qvd);

NoConcatenate 

NewTable:

Load * 

resident OldTable where field1>0;

drop table OldTable;

rename table NewTable to OldTable;

Would that work for you?

[dwforest]

Data is either in your app or not. If in, it would need to be filtered on every chart/measure you want to exclude it,

Sum(<{Fieldname={*}>} value)

={*} select all non-null values.

-={unwanted} would exclude "unwanted" values where unwanted is the literal value, e.g. 6