Discussion board where members can get started with QlikView.
I want to exclude the -- from the given data. Could any one please help me to do this. Its in table and want to exclude in designer part not thru the scripting part. Is this possible to write an expression in designer part which will exclude the -- from the table.
I have tried but it doesn't exclude '--' data from the table. It shows and I want this shouldn't come in to the picture or table. the Entire data should come excluding ''--'' part. FYI.. this is also a field value. Its not a null character.
Are you talking about nulls, or fields that contain '--'?
If you want to elimate nulls, it depends on the data source.For example
FROM data.xls (biff)
Where Len(field2) > 0;
I think the purgechar way will also remove any single hyphens. You could also use
=Replace(Field1, '--', '')
This will not remove single hyphens.
Hope that helps
Then as Jonathan suggested you can use the Replace() Function.
If still it doesnt solve your problem then please upload a sample file.
Do you mean to exclude records with a field containing '--'. Then use
Where Field1 <> '--';
Where Index(Field1, '--');
If you are loading via SQL SELECT, then the where clause will depend on your database.
Hope that helps
Thanks for your reply. But only the thing is I wanted to do all this in designer part without touching the scripting. While loading the data it is possible, I know but I want in designer part. Is this possible.??
Then you need to be specific about the sheet object(s), dimensions and metrics involved.
Here I am attaching the problem, actually I want to exclude the '--' which is one kind of field in data (table) if you will have a look on the attachemnt, the circled marked need not to be shown there, it should be excluded.